Can I use the IF Function?
 

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)

Can I use the IF Function?
 

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)

Can I use the IF Function?
 

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)

Can I use the IF Function?
 

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)

Can I use the IF Function?
 

Hi

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

Arvi Laanemets


"Brian" wrote in message
...
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)

Can I use the IF Function?
 

Works great...Thanks

"Arvi Laanemets" wrote:

Hi

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

Arvi Laanemets


"Brian" wrote in message
...
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)