Help with #NUM error in IRR formula

hasan ahmed
New Contributor

In the attached image and file (See tab B&C, Cell B15,) I'm having difficulties with the IRR formula as it is displaying a #NUM error instead of a numerical value. What seems to be the issue here? IRR.PNG

2 Replies

@hasan ahmed 

IRR requires at least one negative value (as initial cost of business), see at

@hasan ahmed 

Hi Hasan,

While calculating IRR you need to input outflow with negative sign.

I have edited it, please refer the attached file,



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies