Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement for Pricing
I have 2 tabs. The first tab "Interview" has a series of questions that must
be answered. The second tab "Price Tool" has pricing on different items. Depending on how the questions are answered in the "Interview" tab, I want to calculate a price in the "Price Tool" tab. For instance, If "interview" cell B3 = YES, and if "interview" cell B8 = New, then take the price from "Price Tool" cell B6 and multiply it by "interview" cell b9 and place the answer in the "Price Tool" tab. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pricing | Excel Discussion (Misc queries) | |||
Retail pricing to the $x.x9 or $x.x5 | Excel Discussion (Misc queries) | |||
Pricing for Inventory | Excel Discussion (Misc queries) | |||
Old to New Pricing | Excel Worksheet Functions | |||
pricing problems | Excel Worksheet Functions |