Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |