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)