how to Multiply and Add multiple cells ignoring blanks or text

[KariSaga]

I am not very good with excel and need some help. I have searched but not finding what I need. I am trying to figure out a simple formula that calculates multiple cells while ignoring blanks or any other text for cell D. I was trying to use isnumber eg... =IF(AND(ISNUMBER(A2), ISNUMBER(B2)),(A2*B2)+C2,” “)

The end result is below.

A2*B2+C2

	A	B	C	D
1	2	400	100	900
2	2	400		800
3	2	600	N/A	1200

<tbody>
</tbody>

 

[DanteAmor]

What would happen if A or B are blank or text?

Try this




=IFERROR(VALUE(A2),0)*IFERROR(VALUE(B2),0)+IFERROR(VALUE(C2),0)