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

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

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

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

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552757

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

Try this:

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

HTH,
Elkar


"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

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

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


--
punter


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

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

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