CALCULATION OR FUNCTION ERROR

[Gene H]

If anyone can help, I would REALLY appreciate it. I have been fighting with this and researching for hours.

In this spreadsheet A28 needs to calculate a value as follows:

If the figure in A24 is >0, then A15*A24/A27 would be the correct calculation.
But, if the figure in A24=0, then the calculation should be A15*A23/A27.

Thanks in advance

 

[Harlan Grove]

In this spreadsheet A28 needs to calculate a value as follows:

If the figure in A24 is >0, then A15*A24/A27 would be the correct
calculation. But, if the figure in A24=0, then the calculation
should be A15*A23/A27.

If A24 would never be negative,

=A15*IF(A24>0,A24,A23)/A27

 

[Gene H]

It couldn't be a negative number. It is a spreadsheet to calculate retirement income needed and investment returns in different portfolios. A28 is an alternate annual income someone might want instead of their previous income adjusted for inflation during retirement.

Thanks Harlan.