Combined IF statement...

[Brian]

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.

 

[Bob Phillips]

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)

 

[JE McGimpsey]

one way:

=SUMPRODUCT(A1:A3,B1:B3)

 

[Brian]

I'm sorry for that, I'll try to clarify.

In column A there will only be a number in ONE of the rows.
So I want to:
multiple B1*A1 if there is a number in A1 and give result in C1
OR
multiple B2*A2 if there is a number in A2 and give result in C1
OR
multiple B3*A3 if there is a number in A3 and give result in C1

Hope this helps.

 

[Brian]

Thanks JE, that will work.

one way:

=SUMPRODUCT(A1:A3,B1:B3)

 

[Bob Phillips]

=IF(A1<>"",B1*A1,IF(A2<>"",B2*A2,B3*A3))

--

HTH

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

 

[Frank Kabel]

Hi
=SUM(A1:A3)*SUM(B1:B3)
if there really can be only ONE number per column