If the result of a formula is negative make equal to zero

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

Guest

I do have a worksheet that calculates sales profits or losses quarterly in 3
different locations. For each quarter I do have a formula that gives me the
increase or decrease amounts during the last couple of years. For the total
result I need a formula that converts or ignores the negative results. Any
calculation result with a minus sign in the formula should be equal to zero,
so it's not included in the final quaterly total.
Could somebody help me with it? Thanks!
 
You could use the MAX function.

=MAX(A100,0)

This returns the larger of the two values. So, if A100 is ever negative, 0
would be larger, and thus be what is returned.

HTH,
Elkar
 
If you are totalling try:

=SUMIF(K1:K90,">"&0)

adjust the range to suit your needs

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top