V
Vacuum Sealed
Hi All
I use this formula in Column E ( %Gain + / - )
=IF(B4=0,D4,IF(D4<0,D4,IF(D4<>100,(D4-100),IF(B4=0,D4*C4))))
Column A = Day
Column B = Planned
Column C = Actual
Column D = %Actual
Column E = %Gain + / -
Column F = %RunningTotal
It does almost everything I desire, with one minor omition, It does not
return a ( 0 ) when the following condition happens:
If the Planned & Actual = the same, the there is ( 0 ) zero diff + / -
the problem is in the %Gain + / - is returning/displaying a "FALSE"
statement instead of displaying a zero, all the other equations work out
fine, just need to convert the False to a zero and it's finished.
TIA
Mick.
I use this formula in Column E ( %Gain + / - )
=IF(B4=0,D4,IF(D4<0,D4,IF(D4<>100,(D4-100),IF(B4=0,D4*C4))))
Column A = Day
Column B = Planned
Column C = Actual
Column D = %Actual
Column E = %Gain + / -
Column F = %RunningTotal
It does almost everything I desire, with one minor omition, It does not
return a ( 0 ) when the following condition happens:
If the Planned & Actual = the same, the there is ( 0 ) zero diff + / -
the problem is in the %Gain + / - is returning/displaying a "FALSE"
statement instead of displaying a zero, all the other equations work out
fine, just need to convert the False to a zero and it's finished.
TIA
Mick.