IF statement with either/or

leopardhawk

Well-known Member
Joined
May 31, 2007
Messages
611
Office Version
  1. 2016
Platform
  1. Windows
Need help to get the IF statement in F89 working the way I need it to but I keep running into errors as I try to modify it.

Here is the data in question:


Excel 2016 (Windows) 32 bit
EF
81Pension without bridge$ 1,255.14
82CPP$ 1,638.79
83OAS$ 817.97
84Average Gross Payroll (if applicable)$ 1,500.00
85Rental (other) Income$ 900.00
86Manual RRIF$ -
87Auto RRIF$ -
88
89Total Monthly$ 6,111.91
income_analysis
Cell Formulas
RangeFormula
F81=pension!D20
F82='cpp&oas'!E40
F83='cpp&oas'!E42
F87=IFERROR(IF(personal_info!E12="",0,VLOOKUP(YEAR(TODAY())-YEAR(personal_info!E12),rrif!C24:G64,5,1)),0)
F89=IF(F86=0,SUM(F81:F85,(F87)))
The situation I am trying to resolve is that I need the formula in cell F89 to SUM cells F81 to F87 but with the caveat that if F86 is blank to use F87 and if F87 is blank, to use F86 but never both of them together. Appreciate any advice.

Cheers!
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Re: Need help with IF statement with either/or

try

=sum(F81:F85)+if(F86=0,F87,F86)
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top