SOLVED
Home

Help with #NUM error in IRR formula

%3CLINGO-SUB%20id%3D%22lingo-sub-753572%22%20slang%3D%22en-US%22%3EHelp%20with%20%23NUM%20error%20in%20IRR%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753572%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20attached%20image%20and%20file%20(See%20tab%20B%26amp%3BC%2C%20Cell%20B15%2C)%20I'm%20having%20difficulties%20with%20the%20IRR%20formula%20as%20it%20is%20displaying%20a%20%23NUM%20error%20instead%20of%20a%20numerical%20value.%20What%20seems%20to%20be%20the%20issue%20here%3F%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20508px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123229i661222EAAF547202%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22IRR.PNG%22%20title%3D%22IRR.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-753572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753586%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20%23NUM%20error%20in%20IRR%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753586%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F242916%22%20target%3D%22_blank%22%3E%40hasan%20ahmed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIRR%20requires%20at%20least%20one%20negative%20value%20(as%20initial%20cost%20of%20business)%2C%20see%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FIRR-function-64925EAA-9988-495B-B290-3AD0C163C1BC%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FIRR-function-64925EAA-9988-495B-B290-3AD0C163C1BC%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753589%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20%23NUM%20error%20in%20IRR%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753589%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F242916%22%20target%3D%22_blank%22%3E%40hasan%20ahmed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Hasan%2C%3C%2FP%3E%3CP%3EWhile%20calculating%20IRR%20you%20need%20to%20input%20outflow%20with%20negative%20sign.%3C%2FP%3E%3CP%3EI%20have%20edited%20it%2C%20please%20refer%20the%20attached%20file%2C%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
Solution

@hasan ahmed 

IRR requires at least one negative value (as initial cost of business), see at https://support.office.com/en-us/article/IRR-function-64925EAA-9988-495B-B290-3AD0C163C1BC

@hasan ahmed 

Hi Hasan,

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

I have edited it, please refer the attached file,

Thanks,

Tauqeer

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies