You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I'm getting an error while calculating IRR in Numbers saying, "IRR can't be currency." I have tried remove currency for the respective cells, putting them on automatic; however, the issue persists. I have also tried different possibilities e.g., entering amount without comma, with comma, with and without $.
Any help would be greatly appreciated. Thank you!
PS: It's MacOS 10.9.5 (13F34)
IRR takes this form:
So you want something like this:
=IRR(B35:G35,10%)
As you can see the function works with cells formatted as Currency.
There is something strange, though, with your currency formatting. US$ usually takes the form where the , is the thousands separator.
It seems that you have very large positive cash flows after only a small initial cash outflow. I would guess that is not realistic.
SG
IRR takes this form:
So you want something like this:
=IRR(B35:G35,10%)
As you can see the function works with cells formatted as Currency.
There is something strange, though, with your currency formatting. US$ usually takes the form where the , is the thousands separator.
It seems that you have very large positive cash flows after only a small initial cash outflow. I would guess that is not realistic.
SG
I'm not sure whether it's right or wrong.
Can you post a screenshot showing the formula and the table with data?
SG
Thanks for screenshots. But can you also provide the formula you are using?
SG
IRR error in Numbers
