Can I use the IF Function?

G

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)
 
G

Guest

Try this:

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

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

would love help creating a macro to insert information 3
Multiple If Function 2
Data Validation & Dependent Lists -from same list? 5
Count entries in the column translating to minutes. 5
How to Use two search criteria in one array. 2
IF function with value_if_true and value_if_false as equations 4
If function with more than 7 conditions 3
Function that will look at letter in a column and return a number 3

Top