You are approaching the problem the back to front.

What you need is =If(condition1,do this,if not do this).

If you want to meet more than one condition then

=If(and(condition1,condition2,......),do this,if not do this)

Hope this helps

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=508920