View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoZo JoZo is offline
external usenet poster
 
Posts: 1
Default HELP please... easy function

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