I assume if C1 is blank, you get a result of 0?

=IF(C1="",A1*B1,A1*B1*C1)

"David" wrote:

I am having problem with a formula and am wondering if anyone can help. I
have a formula (=A1*B1*C1), where C1 does not always have a value however
excel will not simply just calculate A1*B1 how do i get round this?