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

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 the result of a formula is negative make equal to zero
 

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

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

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 the result of a formula is negative make equal to zero
 

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!

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

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!

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

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!