Here is my situation:

I have a list of three prices in column B (rows 1,2,3), I will be placing a
number (quantity) in column A (in row 1,2,OR 3)corresponding to the price i
want to select.

In column C, the three rows are merged to give one price based on A*B.

How can I use an IF_THEN statement to accomplish this? Or is there a better
way?

Thanks in advance.