| 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 |
| 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 | |||
Threaded Mode
