Valid formula result in Function Box but Cell displays #VALUE

B

bdyer30

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Use TODAY() function as the criteria in a SUMIF formula 1
XIRR 1
Formula Response immediately? 0
#VALUE error which disappears when I use F2, ENTER 1
Formula Displays Instead of Result One Column Only 1
VLOOKUP & Data Validation 0
Conditional formatting based on formula cell 4

Top