leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- 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:
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!
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))) |
Cheers!