I think you misunderstand. I know how to do that. What I'm looking for is a way to calculate the absolute value on the fly.<BR><BR>When entering the range on the series values, I'm currently using ...

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.