LE

Is this something like what you have in mind?

=IF(A200, A20, (IF(A20=0,A21,"A20 may negative")))

ExcelGirl


--
ExcelGirl
------------------------------------------------------------------------
ExcelGirl's Profile: http://www.excelforum.com/member.php...o&userid=25272
View this thread: http://www.excelforum.com/showthread...hreadid=387652