Strange Request - Possible If Function Formula

[snaplink22]

I'm looking for a formula that will allow me to multiple one cell by another cell, but if the cell to the right of that one has data then that cell is the one to be multiplied. Here's an example of what I'm hoping to accomplish:

A1 - 100
D1 - $1.00
E1 - =A1*D1

However, if cell B1 is populated I want cell E1 to multiple by the value in B1 versus A1:

A1 - 100
B1 - 150
D1 - $1.00
E1 - =B1*D1

Ideally, I would like to repeat this step all the way up to cell C1.

I'm assuming this is a simple If function, but I can't see to find the right combination.

 

[JoeMo]

One way:

=IF(ISNUMBER(C1),C1*D1,IF(ISNUMBER(B1),B1*D1,A1*D1))

 

[jtakw]

Hi,

Another way:

Book1
	A	B	C	D	E
1	100	150		1	150
Sheet127

Cell Formulas
Range	Formula
E1	=LOOKUP(9.99999999999999E+307,A1:C1)*D1

 

[snaplink22]

JoeMo

That did it! Thank you very much!

 

[JoeMo]

JoeMo

That did it! Thank you very much!

You are welcome - thanks for the reply.