If Statement for Pricing

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

 

[Guest]

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

 

[JP]

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

 

[JP]

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 -