Replacing negative formual results with a zero.
 

I am doing simple addition and subtraction formulas that result feed into
other formulas so I want to restrict the results to a zero if the initial
formula results revert to zero if they are negative.

Replacing negative formual results with a zero.
 

=MAX(0,yourformula)

Regards,
Stefi



€žsmittys1€� ezt Ã*rta:

I am doing simple addition and subtraction formulas that result feed into
other formulas so I want to restrict the results to a zero if the initial
formula results revert to zero if they are negative.

Replacing negative formual results with a zero.
 

=if(A1-B1<0,0,A1-B1)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=567021