View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default I know this is easy but I don't remember how.

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

HTH
--
AP

"punter" a écrit dans
le message de news: ...

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