View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Smith Karen Smith is offline
external usenet poster
 
Posts: 45
Default 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.