CALCULATION OR FUNCTION ERROR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Gene H said:
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.
Click to expand...

If A24 would never be negative,

=A15*IF(A24>0,A24,A23)/A27
 
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.
 
Back
Top