Home

Finding for IRR

%3CLINGO-SUB%20id%3D%22lingo-sub-809662%22%20slang%3D%22en-US%22%3EFinding%20for%20IRR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809662%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20find%20for%20IRR%20on%20worksheet%201%20using%20arguments%20from%20worksheet%202.%20How%20do%20I%20write%20the%20formula%3F%26nbsp%3B%20I%20am%20not%20able%20to%20click%20on%20my%20mouse%20on%20a%20list%20of%20cashflows%20to%20find%20for%20the%20IRR.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-809662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFinding%20for%20IRR%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809742%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20for%20IRR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809742%22%20slang%3D%22en-US%22%3EIn%20entering%20the%20values%20argument%2C%20press%20Ctrl%2BPgDn%20to%20go%20to%20Sheet2%2C%20then%20select%20the%20range%20of%20values%20by%20pressing%20Shift%2BArrowDown.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811973%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20for%20IRR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811973%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20an%20Alternative%20Cash%20Sales%20Worksheet%20(ACSW)%20that%20requires%20arguments%20from%20my%20Cash%20Flow%20Analysis%20Worksheet%20(CFAW).%26nbsp%3B%20The%20IRR%20formula%20is%20located%20on%20my%20ACSW%20worksheet%2C%26nbsp%3B%20cell%20O53.%26nbsp%3B%20To%20calculate%20IRR%2C%20I%20need%20the%20cash%20flows%20of%20-1%2C040%2C000%20in%20CFAW%20located%20in%20cell%20P8%2C%20%24155%2C100%20located%20in%20cell%20H32%2C%20etc.%20cell%20J32%2C%20cell%20N32%2C%20cell%20P32%2C%20and%20cell%20(R32%2B%20ACSW!N42).%26nbsp%3B%20I%20tried%20writing%20the%20formula%20in%20worksheet%20ACSW%2C%20cell%20O53%2C%20finding%20for%20IRR%2C%20as%20follows%3A%26nbsp%3B%26nbsp%3B%3DIRR(%22-CFAW!P8%2BCFAW!H32%2BCFAW!J32%2BCFAW!N32%2BCFAW!P32%2B9%2B(CFAW!R32%2BACSW!N18))%22).%26nbsp%3B%20The%20answer%20I%20receive%20is%20%22VALUE%22.%20I%20have%20arguments%20on%20different%20pages%20and%20cells%20and%20am%20not%20able%20to%20simply%20scan%20over%20all%20the%20arguments%20to%20find%20for%20IRR.%26nbsp%3B%20Thank%20you%20in%20advance%20for%20your%20consideration.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Maurice1099
New Contributor

I need to find for IRR on worksheet 1 using arguments from worksheet 2. How do I write the formula?  I am not able to click on my mouse on a list of cashflows to find for the IRR.   

2 Replies
In entering the values argument, press Ctrl+PgDn to go to Sheet2, then select the range of values by pressing Shift+ArrowDown.

Thank you for your reply.

 

I am working on an Alternative Cash Sales Worksheet (ACSW) that requires arguments from my Cash Flow Analysis Worksheet (CFAW).  The IRR formula is located on my ACSW worksheet,  cell O53.  To calculate IRR, I need the cash flows of -1,040,000 in CFAW located in cell P8, $155,100 located in cell H32, etc. cell J32, cell N32, cell P32, and cell (R32+ ACSW!N42).  I tried writing the formula in worksheet ACSW, cell O53, finding for IRR, as follows:  =IRR("-CFAW!P8+CFAW!H32+CFAW!J32+CFAW!N32+CFAW!P32+9+(CFAW!R32+ACSW!N18))").  The answer I receive is "VALUE". I have arguments on different pages and cells and am not able to simply scan over all the arguments to find for IRR.  Thank you in advance for your consideration.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 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