Thread: NPV
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
hm hm is offline
external usenet poster
 
Posts: 9
Default NPV

good idea, Ron. i will try this. you have been very helpful. thanks.
--
hm


"Ron Rosenfeld" wrote:

On Mon, 25 Sep 2006 19:27:02 -0700, hm wrote:

thanks, Ron. I agree and have tried, but if I do the calculation =NPV(rate,
A1:A24, B!:B24), I get a numerical value which is nonsensically smaller than
what it should be. certainly not what I would get on my HP 12-C financial
calculator. any ideas?


My first guess would be that there is something funny about your data. Perhaps
some of the values that appear to be numeric are really text.

The reliable way to check that is to execute =ISTEXT(cell_ref) on each cell.

Or you could enter an **ARRAY** formula =OR(ISTEXT(A1:B24)).

To enter an **ARRAY** formula, hold down <ctrl<shift while hitting <enter.
If you did it correctly, Excel will place braces {...} around the formula. If
the above formula gives a result of TRUE, then some of your entries are TEXT
and will not be interpreted as numeric values by the formula.

Another possibility is that, because of cell formatting, you are not seeing the
true contents of the cell, and that is skewing the results.

Also, if "rate" is text (do the ISTEXT(rate)), that would also give you a small
value.

If that is not the problem, if you can, post the values you are using and let's
see what we get on a different machine.
--ron