Try this

=IF(A5=0,"",(A5*B5)/C5)

You seem to be using ; in your version of Excel where I use , so make the
necessary changes to suit your region.

Mike

"JoZo" wrote:

Hi,
I have a problem.
Here is the main formula:
=(A5*B5)/C5
but if there is nothing( blank) in cells A5 and C5 i got #DIV/0!
I don't want to have this error #DIV/0!, i just want that IF cells A5
and C5 are blank result 0 (ZERO).

I tried with that formula but is not working:

=IF(A5="blank";0;(A5*B5)/C5)

Can anyone help me please?

Thanks a lot
.