Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Valid formula result in Function Box but Cell displays #VALUE
I am using the XIRR function with a complex series of dates and cash flows.
The function returns #VALUE, but when I look in the formula box, it indicates a numerical formula result that makes sense. Why is this happening and how do I get the number to show up in the cell? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions |