If Cell A1 is blank move to A2 and Perform multiplications

[dream_life]

I have googles and test share amount of formulas but going nowhere. I have some blank or non Blank cells in same Column. I am looking for formula if A1 is blank, it can move to A2, pick the amount and multiply it what is in C2, but if there is value in A1, ignore A2 and multiply A1 to C1. I greatly appreciate if someone can help.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

If it's just the 2 rows:

Book1
	A	B	C	D	E	F
1			12		26	26
2	2		13
Sheet471

Cell Formulas
Range	Formula
E1	=IF(A1="",A2*C2,A1*C1)
F1	=IF(A1,A1*C1,A2*C2)