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!

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

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


"Nrippe" wrote:

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!

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


with @tiscali.co.uk


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

Thank you very much! It works perfectly.

"Trevor Shuttleworth" wrote:

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

You're welcome, thanks for the feedback


"Nrippe" wrote in message
...
Thank you very much! It works perfectly.

"Trevor Shuttleworth" wrote:

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