Formula/Equation
 

How do I construct a formula or equation in a cell that if the cell above it
is is zero, the cell will be zero, or if the amount is over 20 it will
subtract the difference?
--
Brook

Formula/Equation
 

Hi

Subtract the difference of what?

Andy.

"Brook" wrote in message
...
How do I construct a formula or equation in a cell that if the cell above
it
is is zero, the cell will be zero, or if the amount is over 20 it will
subtract the difference?
--
Brook