IF statement with either/or

[leopardhawk]

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
	E	F
81	Pension without bridge	$ 1,255.14
82	CPP	$ 1,638.79
83	OAS	$ 817.97
84	Average Gross Payroll (if applicable)	$ 1,500.00
85	Rental (other) Income	$ 900.00
86	Manual RRIF	$ -
87	Auto RRIF	$ -
88
89	Total Monthly	$ 6,111.91
income_analysis

Cell Formulas
Range	Formula
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!

 

[AlanY]

Re: Need help with IF statement with either/or

try

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

 

[leopardhawk]

Thank you!

 

[AlanY]

you're welcome