How can I get the XIRR funct to work for a positive first number?

G

Guest

How can I get the XIRR function to work for a positive number in the first
value cell? The XIRR works when you cut and paste the HELP example on
Microsoft's home page but not when you input real values. I already completed
the Add-in step.
 
R

Ron Rosenfeld

How can I get the XIRR function to work for a positive number in the first
value cell? The XIRR works when you cut and paste the HELP example on
Microsoft's home page but not when you input real values. I already completed
the Add-in step.
Click to expand...

XIRR will work perfectly fine with the first number being positive.

If it is not working for you, than the problem lies elsewhere.

Perhaps if you supply more information ...


--ron
 

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

Should I trust XIRR or Legal & General? 5
Can XIRR start with a "0" in the first period 4
XIRR and Non Contiguous Cells 2
How do I change the sign of a base number for use in XIRR? 1
Change positive number to negative number 1
How do I limit formula results to positive only? 4
How to Show "+" for positive and "-" for negative 10
how can I pick up a nearest value to zero 3

Top