calculate 2 cells,never negative

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

Guest

hello

I want to calculate two cells, and when the outcom is positive then just
show the calculation. On the other hand when the calculation is negative it
must give 0 as a result.
So it's never a <0 figure
What do I use.

Thx in advance
 
=MAX(0,SUM(A1,B1))


just change the calculation part to whatever you are doing.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Don't know what you mean by "calculate two cells", but this will give
you what you want:

=MAX(0,your_calculation)

Hope this helps.

Pete
 
Hello pete/bob

I think i wrote badly what i want
example:



10-5=5
10-9=1
10-10=0
10-12=0

as soon the outcom is <0 it's given a zero

thx for your help
 
which is what we both gave you.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You are obviously subtracting one cell from another - assume these are
A1 and B1, then the formula becomes:

=MAX(0,A1-B1)

or maybe:

=MAX(0,B1-A1)

Hope this helps.

Pete
 
Back
Top