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.
|