Thanks Dana for your response, the formula works great, however, if
there there is no amount in F35, the response is still 20, I need it to
be zero...


--
terry_d
------------------------------------------------------------------------
terry_d's Profile: http://www.excelforum.com/member.php...o&userid=32678
View this thread: http://www.excelforum.com/showthread...hreadid=524843