trying to create a else/if statement, at least I think so.
Cell D4, D5, D6, D7, D8 and D9 may or may not have a number,in this case a number such as 5%, 6% etc. I’ll work with line 7 for demonstration purposes. D7 currently has the value of 5%. In cell E7 I’m using this formula: =($G16*D7)/12 The formulaworks perfectly.
In some cases, D7 will be empty. If I remove the value of 5% from D7 and leave it empty, and I replace the first formula with this,
=SUMPRODUCT(--([GrowthGoals2019.xlsx]Flat!$C$3:$C$200=$B7),[GrowthGoals2019.xlsx]Flat!$F$3:$F$200) It works perfectly.
Now I need to combine the two so the first formula applies whenever there is a value in D7, but if D7 is empty, the second formula applies.
Thanks in advance
Cell D4, D5, D6, D7, D8 and D9 may or may not have a number,in this case a number such as 5%, 6% etc. I’ll work with line 7 for demonstration purposes. D7 currently has the value of 5%. In cell E7 I’m using this formula: =($G16*D7)/12 The formulaworks perfectly.
In some cases, D7 will be empty. If I remove the value of 5% from D7 and leave it empty, and I replace the first formula with this,
=SUMPRODUCT(--([GrowthGoals2019.xlsx]Flat!$C$3:$C$200=$B7),[GrowthGoals2019.xlsx]Flat!$F$3:$F$200) It works perfectly.
Now I need to combine the two so the first formula applies whenever there is a value in D7, but if D7 is empty, the second formula applies.
Thanks in advance
Last edited: