Put a 0 in for the value_if_false argument. Standard IF syntax:
=IF(condition,value_if_true,value_if_false), so for your first formula:
=IF(AD7<0,AD7*-1,0)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=392143