punter Wrote:
if the cell is question is blank

what cell would that be? I assume you mean some cell other than C2!?

Assuming your 'possible blank cell' is B2, then this should work.

=IF(AND(OR(C2=7,C2=11),B2=""), "FedEx Weekly Charge", "")

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553174