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

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

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

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

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

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