Formula

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

Guest

I am trying to input a formula that when I subtract the contents of one cell
from another if the sum is negative, I want a zero to show in the cell. If
the sum of the cell is a positive number then I want the sum to show in the
cell.

This is what I have tried =IF(G4-H4<=0,0). The only problem with it is
every time the sum of the cell comes up positive it gives me a false
statement. If the sum is positive I want to see that sum.
 
Need another argument to tell Excel what to do if value is not <= 0

=IF(G4-H4<=0,0,G4-H4)

Another method.........=MAX(0,G4-H4)


Gord Dibben MS Excel MVP


On Fri, 29 Sep 2006 11:06:02 -0700, Christine Haines <Christine
 
It worked! Thank you so much!!!!!

Gord Dibben said:
Need another argument to tell Excel what to do if value is not <= 0

=IF(G4-H4<=0,0,G4-H4)

Another method.........=MAX(0,G4-H4)


Gord Dibben MS Excel MVP


On Fri, 29 Sep 2006 11:06:02 -0700, Christine Haines <Christine
Click to expand...
 
Back
Top