| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i sum A1*B1 through to A12*B12 in one easy forumla? | Excel Worksheet Functions | |||
| Easy question? Page numbers | Excel Discussion (Misc queries) | |||
| Excel does not remember printer settings | Setting up and Configuration of Excel | |||
| OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
| new user with easy question? not easy for me | New Users to Excel | |||
Hybrid Mode
