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"),Int erview!B9*'Price Tool'!B6,0)

Will

"Karen Smith" wrote:

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.

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


On Oct 26, 4:42 pm, Karen Smith
wrote:
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.

JINX!

:-)

On Oct 26, 5:02 pm, roadkill
wrote:
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"),Int erview!B9*'Price Tool'!B6,0)

Will



"Karen Smith" wrote:
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.- Hide quoted text -

- Show quoted text -