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.

Any ideas?

James,

Can You upload an example as I'm having difficulties to follow Your written words.

Kind regards,
Dennis