If Statement for Pricing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You didn't say what to put in the cell if these conditions are not met. But
assuming you just want to put 0 (zero) you would put something like this in
the cell on the "Price Tool" tab.

=IF(AND(Interview!B3="YES",Interview!B8="New"),Interview!B9*'Price Tool'!B6,0)

Will
 
JINX!

:-)

You didn't say what to put in the cell if these conditions are not met. But
assuming you just want to put 0 (zero) you would put something like this in
the cell on the "Price Tool" tab.

=IF(AND(Interview!B3="YES",Interview!B8="New"),Interview!B9*'Price Tool'!B6,0)

Will






- Show quoted text -
Click to expand...
 
Back
Top