Omitting Negative Numbers

C

Caplin Girl

Hi there,
I'm wondering if there is a formula that will omit a number from a table
when it is negative. If so, please inform me how to add it to a formula that
looks like this:
=SUM(B90,B109,B149,B168)-B128-B187
Thanks.
 
C

Caplin Girl

sorry, this didn't work. i put your formula
=MAX(B90,0)+MAX(B109,0)+MAX(B149,0)+MAX(B168,0)-MAX(B128,0)-MAX(B187,0) in,
but the result is still -2. I need that cell to read 0 to make the table
useful.

have i done something wrong?
i have very little experience working with excel, so maybe you left
something out that would seem obvious to you?
 
G

Gary''s Student

The formula treats all the B's as zero if they are negative, but if B128 or
B187 is/are really big, the final result can still be negative.
 
C

Caplin Girl

I just found a different post that suggested this which worked perfectly.
=MAX(0,SUM(B90,B109,B149,B168)-B128-B187)
Thanks for your assistance today!
 
Top