I am trying to create a little spreadsheet that can be used as a quick quoting device. Everything has been pretty simple so far - [but] - I am trying to create a drop down menu with two options; one being YES and the second being NO. This item when the user selects YES will multiply a fixed amount by user inputed amount from previous two cells to create a price for an item.
Example: There are four main columns; column A (ITEM), column B(QUANITY), column C (PRICE), and column D (TOTAL)
This drop down menu will only be effected by ITEM A and ITEM B, lets say the user has established this quote will have 8 of Item A and 2 of Item B.
I need to take that total of 10 multiply it by 20 to create 200 in column D.