| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF function (maybe OR)
Hi all,
I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF function (maybe OR)
=IF(OR(B1={1,2,3,9}),"X","")
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mpenkala" wrote in message ... Hi all, I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF function (maybe OR)
Perfect - thanks Bernard.
Matt "Bernard Liengme" wrote: =IF(OR(B1={1,2,3,9}),"X","") best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mpenkala" wrote in message ... Hi all, I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF function (maybe OR)
Hey Bernard,
how can I modify this formula so that it doesn't give me an "x" when the cell is blank and my formula is =IF(OR(B1={0,1,2,7}),"X","") Thanks! Matt "Bernard Liengme" wrote: =IF(OR(B1={1,2,3,9}),"X","") best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mpenkala" wrote in message ... Hi all, I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF function (maybe OR)
=IF(B1="","",IF(OR(B1={0,1,2,7}),"X",""))
or =IF(AND(B1<"",OR(B1={0,1,2,7})),"X","") -- David Biddulph "mpenkala" wrote in message ... Hey Bernard, how can I modify this formula so that it doesn't give me an "x" when the cell is blank and my formula is =IF(OR(B1={0,1,2,7}),"X","") Thanks! Matt "Bernard Liengme" wrote: =IF(OR(B1={1,2,3,9}),"X","") best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mpenkala" wrote in message ... Hi all, I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IF function (maybe OR)
Hey David,
thanks - works great! Matt "David Biddulph" wrote: =IF(B1="","",IF(OR(B1={0,1,2,7}),"X","")) or =IF(AND(B1<"",OR(B1={0,1,2,7})),"X","") -- David Biddulph "mpenkala" wrote in message ... Hey Bernard, how can I modify this formula so that it doesn't give me an "x" when the cell is blank and my formula is =IF(OR(B1={0,1,2,7}),"X","") Thanks! Matt "Bernard Liengme" wrote: =IF(OR(B1={1,2,3,9}),"X","") best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mpenkala" wrote in message ... Hi all, I need some help with a chart I'm making. I want an if function to do the following: IF B1=1,2,3 or 9, then mark B2 with an "x". Should be simple, but I can never figure out the multiple numbers. Thanks, Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF Function | Excel Worksheet Functions | |||
| Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
| Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
| IF function for multiple answers? | Excel Worksheet Functions | |||
| Multiple OR function | Excel Worksheet Functions | |||
Linear Mode
