IF statement
You could also try
=(C29C26)*(C29-C26)
The equation in first set of brackets returns 1 if true, 0 if false, and
the equation in the second set of brackets is multiplied by that value
Boatman
"help!" wrote:
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is <=0, I want the cell
to display 0.
Can I use an IF statment for this? How would I do this?
thanks!
|