Zero a cell if negative

python25 · May 2nd, 2002, 09:07 AM

Is there a formula, that

If I add up some cell and they come out negative the outcome is always 0 Zero?

I do not want to have any negative numbers.

don't know in dallas · May 2nd, 2002, 09:12 AM

=if(a1+b1<0,"",a1+b1). Did I understand your question correctly? DiD

Jay Petrulis · May 2nd, 2002, 09:39 AM

Try,

=MAX(0,your sum formula)

If the result > 0, the sum formula holds. If <=0, the 0 is the max and is returned.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 09:07 AM	#1
python25 New Member Join Date: May 2002 Posts: 1	Is there a formula, that If I add up some cell and they come out negative the outcome is always 0 Zero? I do not want to have any negative numbers.

May 2nd, 2002, 09:12 AM	#2
don't know in dallas New Member Join Date: Apr 2002 Location: dallas, tx Posts: 4	=if(a1+b1<0,"",a1+b1). Did I understand your question correctly? DiD

May 2nd, 2002, 09:39 AM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Try, =MAX(0,your sum formula) If the result > 0, the sum formula holds. If <=0, the 0 is the max and is returned.