have you tired the "if" function? =if(expression, result 1, result2)

result 1 if expression is true, else result 2


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=276820