=IF(yourformula<0,0,yourformula)

Regards

Trevor


"Nrippe" wrote in message
...
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!