| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if formula with variables
I have a spreadsheet that I need to take the base cost of an item and add an
option if it applies to that item. Example Apples = 2.00 Apples with caramel = 2.50 Apples with maple = 2.50 Apples with Peanut butter = 3.00 Apples with Jelly = $3.00 I have my if number in column D, I have my variable (caramel, maple, etc listed in column I with the correspondening number in column H. my pricing for the option is in column J. This is kind of what I need =if(d2=h3:h7),j3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formula with variables
I read this as:
You have a list of option numbers with names. 1 = Caramel, 2 = maple, etc. These options have corresponding prices. This information is arranged whe Column H is option number, column I is option name, column J is option price. And you want to look up an option number from column D, then return an option price. If that is the case, you can use VLOOKUP to return the price. Assuming the lookup data begins in row 3 and the option/name/price list ends at row 7: In E2 enter: =VLOOKUP(D2,$H$3:$J$7,3) "Ronda" wrote: I have a spreadsheet that I need to take the base cost of an item and add an option if it applies to that item. Example Apples = 2.00 Apples with caramel = 2.50 Apples with maple = 2.50 Apples with Peanut butter = 3.00 Apples with Jelly = $3.00 I have my if number in column D, I have my variable (caramel, maple, etc listed in column I with the correspondening number in column H. my pricing for the option is in column J. This is kind of what I need =if(d2=h3:h7),j3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formula with variables
Sorry, this requires something extra:
=VLOOKUP(D2,$H$3:$J$7,3,FALSE) "~L" wrote: I read this as: You have a list of option numbers with names. 1 = Caramel, 2 = maple, etc. These options have corresponding prices. This information is arranged whe Column H is option number, column I is option name, column J is option price. And you want to look up an option number from column D, then return an option price. If that is the case, you can use VLOOKUP to return the price. Assuming the lookup data begins in row 3 and the option/name/price list ends at row 7: In E2 enter: =VLOOKUP(D2,$H$3:$J$7,3) "Ronda" wrote: I have a spreadsheet that I need to take the base cost of an item and add an option if it applies to that item. Example Apples = 2.00 Apples with caramel = 2.50 Apples with maple = 2.50 Apples with Peanut butter = 3.00 Apples with Jelly = $3.00 I have my if number in column D, I have my variable (caramel, maple, etc listed in column I with the correspondening number in column H. my pricing for the option is in column J. This is kind of what I need =if(d2=h3:h7),j3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formula with variables
Thanks for your help. I did get the Vlookup to work without the false. Can
you tell me what that is for? "~L" wrote: Sorry, this requires something extra: =VLOOKUP(D2,$H$3:$J$7,3,FALSE) "~L" wrote: I read this as: You have a list of option numbers with names. 1 = Caramel, 2 = maple, etc. These options have corresponding prices. This information is arranged whe Column H is option number, column I is option name, column J is option price. And you want to look up an option number from column D, then return an option price. If that is the case, you can use VLOOKUP to return the price. Assuming the lookup data begins in row 3 and the option/name/price list ends at row 7: In E2 enter: =VLOOKUP(D2,$H$3:$J$7,3) "Ronda" wrote: I have a spreadsheet that I need to take the base cost of an item and add an option if it applies to that item. Example Apples = 2.00 Apples with caramel = 2.50 Apples with maple = 2.50 Apples with Peanut butter = 3.00 Apples with Jelly = $3.00 I have my if number in column D, I have my variable (caramel, maple, etc listed in column I with the correspondening number in column H. my pricing for the option is in column J. This is kind of what I need =if(d2=h3:h7),j3 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formula with variables
The last argument of VLOOKUP is TRUE or FALSE. FALSE means exact match, TRUE
means closest match. If omitted, TRUE is the default value. Glad I could help! "Ronda" wrote: Thanks for your help. I did get the Vlookup to work without the false. Can you tell me what that is for? "~L" wrote: Sorry, this requires something extra: =VLOOKUP(D2,$H$3:$J$7,3,FALSE) "~L" wrote: I read this as: You have a list of option numbers with names. 1 = Caramel, 2 = maple, etc. These options have corresponding prices. This information is arranged whe Column H is option number, column I is option name, column J is option price. And you want to look up an option number from column D, then return an option price. If that is the case, you can use VLOOKUP to return the price. Assuming the lookup data begins in row 3 and the option/name/price list ends at row 7: In E2 enter: =VLOOKUP(D2,$H$3:$J$7,3) "Ronda" wrote: I have a spreadsheet that I need to take the base cost of an item and add an option if it applies to that item. Example Apples = 2.00 Apples with caramel = 2.50 Apples with maple = 2.50 Apples with Peanut butter = 3.00 Apples with Jelly = $3.00 I have my if number in column D, I have my variable (caramel, maple, etc listed in column I with the correspondening number in column H. my pricing for the option is in column J. This is kind of what I need =if(d2=h3:h7),j3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variables in URL formula help | Excel Discussion (Misc queries) | |||
| IF formula for 13 plus variables | Excel Worksheet Functions | |||
| How to plot a formula with two variables | Charts and Charting in Excel | |||
| cell variables in IF formula | Excel Discussion (Misc queries) | |||
|
< |
Excel Worksheet Functions | |||
Linear Mode
