Can I use the IF Function?

[Guest]

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)

 

[Guest]

Try this:

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

HTH,
Elkar

 

[Guest]

Everything shows up as 17.75

Try this:

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

HTH,
Elkar

 

[Guest]

it works great! THANKS!

Try this:

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

HTH,
Elkar

 

[Arvi Laanemets]

Hi

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

Arvi Laanemets

 

[Guest]

Works great...Thanks

Hi

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

Arvi Laanemets