if your're trying to save some space, this might work:
=IF(OR(A2={7,11}),"FedEx Weekly Charge","")

"punter" wrote:


Hi,

I'm having a little issue with an IF formula. I want the formula
return "FedEx Weekly Charge" into a cell if the number it is reading is
either 7 or 11. I can get one to work but not both. Example:

=if(A2=7,"FedEx Weekly Charge")

How do i get it to return "FedEx Weekly Charge" if the number is either
7 or 11?

Thanks

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=552757