renegan Wrote:
If your cell gives negative values due to a formula try this:

=if(FORMULA IN CELL<0,0,FORMULA IN CELL)


...or

=MAX(0,formula)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528761