I know this is easy but I don't remember how.

[punter]

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

 

[Ardus Petus]

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

HTH

 

[Bearacade]

=IF(OR(A2=7,A2=11), "FedEx Weekly Charge", "")

 

[Guest]

Try this:

=IF(OR(A2=7,A2=11),"FedEx Weekly Charge")

HTH,
Elkar

 

[punter]

Thanks much. I know it was something simple like that.

 

[Guest]

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