#VALUE in cell but pop up function box show right number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the XIRR funciton in Excel 2003. The cell shows #VALUE but when I
click on the function to open the Functions Arguement box, the number is
properly calculated in the 'Formula Results'.

Any experience this problem? Have a solution?

[I have been using Excel for financial valuation for years and I know what
the number should be so it is not a simple question of the wrong inputs -
like I said, when the Function window is up, the right answer is displayed -
I just can't read it in the cell which displays #VALUE.]
 
Hi
post yiour exact formula and the values in the referenced cells
 
You must log in or register to reply here.

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

Numbers showing Up Centered in Cell ? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Run time 1004 5
Sum over a variable number of cells 3
pop-up box 1
IF function not calculating 3
Countif Conditions - Use of conditions that vary by cell value 1
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top