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

  • Thread starter Thread starter punter
  • Start date Start date
P

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
 
if your're trying to save some space, this might work:
=IF(OR(A2={7,11}),"FedEx Weekly Charge","")
 
Back
Top