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

[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!

 

[Trevor Shuttleworth]

=IF(yourformula<0,0,yourformula)

Regards

Trevor

 

[Guest]

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

 

[Sandy Mann]

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

 

[Guest]

Thank you very much! It works perfectly.

=IF(yourformula<0,0,yourformula)

Regards

Trevor

 

[Trevor Shuttleworth]

You're welcome, thanks for the feedback

Thank you very much! It works perfectly.