Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 16th 19, 07:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 1
Default How to run the IRR formula with non-adjacent cells in Google Sheets

Hello all,

I have a template for a cost-benefit analysis, and one aspect is the IRR. When I open the template on my Windows 10 desktop, there is no issue. But when I open the template on Google Sheets on my Chromebook, the IRR formula returns a #NUM! error. I think the problem is that the cashflows are in non-adjacent cells. So basically I want to run the IRR formula in Google Sheets where my first cash outflow is in one cell, and the rest of the cashflows are in a range of adjacent cells.

The formula is =IRR((J8, E9:E15))

In this, J8 contains the initial outflow, while the E9:E15 range contains the rest of the inflows.

The reason I suspect this has to do with the adjacency of the cells is because there is a second IRR calculation in the spreadsheet where all the cashflows are in adjacent cells, and that formula works fine on Google Sheets.

If I've explained this badly or you need more information, let me know. Also, I could upload the spreadsheet, but I'm not sure how as this is my first time posting a question here.

Thanks in advance.


  #2   Report Post  
Old April 19th 19, 12:17 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,001
Default How to run the IRR formula with non-adjacent cells in Google Sheets

Hello all,

I have a template for a cost-benefit analysis, and one aspect is the IRR.
When I open the template on my Windows 10 desktop, there is no issue. But
when I open the template on Google Sheets on my Chromebook, the IRR formula
returns a #NUM! error. I think the problem is that the cashflows are in
non-adjacent cells. So basically I want to run the IRR formula in Google
Sheets where my first cash outflow is in one cell, and the rest of the
cashflows are in a range of adjacent cells.

The formula is =IRR((J8, E9:E15))

In this, J8 contains the initial outflow, while the E9:E15 range contains the
rest of the inflows.

The reason I suspect this has to do with the adjacency of the cells is
because there is a second IRR calculation in the spreadsheet where all the
cashflows are in adjacent cells, and that formula works fine on Google
Sheets.

If I've explained this badly or you need more information, let me know. Also,
I could upload the spreadsheet, but I'm not sure how as this is my first time
posting a question here.

Thanks in advance.


Since Google Sheets *is not Excel-based* even though it claims to be 100% Excel
compatible, you should consult the Google Sheets online guide for using *their*
IRR function in *their* spreadsheet in terms of cell references. While it
should be essentially same as Excel, I've found in numerous instances some
references going awry when testing Excel templates on Google Sheets.

Note that I stopped doing this when I decided to use SpreadsheetGear in
stand-alone Windows apps; - it creates true 100% Excel-compatible workbooks
while having absolutely no dependency on MS Office whatsoever!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
GOOGLE SHEETS NOT BEHAVING CORRECTLY Abz Trainer Excel Worksheet Functions 1 June 14th 17 01:15 AM
Formula works in google sheets but not in Excel, how to make it works? Pat[_26_] Excel Programming 3 March 5th 14 11:34 AM
Formula omits adjacent cells Ali Excel Discussion (Misc queries) 2 March 22nd 09 06:19 AM
Formula to sum non-adjacent cells Jack_Feeman Excel Programming 7 March 28th 08 08:49 AM
How can I add non-adjacent cells with a formula dhodges00 Excel Worksheet Functions 3 January 12th 05 04:46 PM


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017