Can I use the IF Function?

[Brian]

Column D is a dropdown list of shirt sizes from S to 4X.
I am trying to get the price to show up in Column F, depending on what size
appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
are 19.75. I got this formula to work for one size only:
=IF(D4="S",17.75,19.75)

[Elkar]

Try this:

=IF(OR(D4={"S","M","L","XL"}),17.75,IF(OR(D4={"2X","3X","4X"}),19.75,""))

HTH,
Elkar


"Brian" wrote:

> Column D is a dropdown list of shirt sizes from S to 4X.
> I am trying to get the price to show up in Column F, depending on what size
> appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
> are 19.75. I got this formula to work for one size only:
> =IF(D4="S",17.75,19.75)
>

[Brian]

Everything shows up as 17.75



"Elkar" wrote:

> Try this:
>
> =IF(OR(D4={"S","M","L","XL"}),17.75,IF(OR(D4={"2X","3X","4X"}),19.75,""))
>
> HTH,
> Elkar
>
>
> "Brian" wrote:
>
> > Column D is a dropdown list of shirt sizes from S to 4X.
> > I am trying to get the price to show up in Column F, depending on what size
> > appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
> > are 19.75. I got this formula to work for one size only:
> > =IF(D4="S",17.75,19.75)
> >

[Brian]

it works great! THANKS!

"Elkar" wrote:

> Try this:
>
> =IF(OR(D4={"S","M","L","XL"}),17.75,IF(OR(D4={"2X","3X","4X"}),19.75,""))
>
> HTH,
> Elkar
>
>
> "Brian" wrote:
>
> > Column D is a dropdown list of shirt sizes from S to 4X.
> > I am trying to get the price to show up in Column F, depending on what size
> > appears in Column D. S through XL shirts are 17.75 and 2X through 4X shirts
> > are 19.75. I got this formula to work for one size only:
> > =IF(D4="S",17.75,19.75)
> >

[Arvi Laanemets]

Hi

=17.75+ISNUMBER(MATCH(D4,{"2X";"3X";"4X"},0))*2

Arvi Laanemets


"Brian" <[email protected]> wrote in message
news:[email protected]...
> Column D is a dropdown list of shirt sizes from S to 4X.
> I am trying to get the price to show up in Column F, depending on what
size
> appears in Column D. S through XL shirts are 17.75 and 2X through 4X
shirts
> are 19.75. I got this formula to work for one size only:
> =IF(D4="S",17.75,19.75)
>

[Brian]

Works great...Thanks

"Arvi Laanemets" wrote:

> Hi
>
> =17.75+ISNUMBER(MATCH(D4,{"2X";"3X";"4X"},0))*2
>
> Arvi Laanemets
>
>
> "Brian" <[email protected]> wrote in message
> news:[email protected]...
> > Column D is a dropdown list of shirt sizes from S to 4X.
> > I am trying to get the price to show up in Column F, depending on what
> size
> > appears in Column D. S through XL shirts are 17.75 and 2X through 4X
> shirts
> > are 19.75. I got this formula to work for one size only:
> > =IF(D4="S",17.75,19.75)
> >
>
>
>