You haven't given any details of what tests are applicable to the IFs.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
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.