=IFERROR(D3*E3,"") shows 0 instead of blank cell on error
=IFERROR(D3/H3,"") shows blank instead of 0 on error

I would like to show blank cells on error in both cases



Thankyou,
Al

The error will trip in the second equation if the H3 is zero (divide by zero).

The error will only trip in the first equation if there is a non-numeric in one of the cells.

Thanks for reply gbobs, What I am trying to do is have a blank result if any of the cells in equation are blank. This happens in both equations above. the only difference is that one is divided by and the other is multiplied by. (trying not to have worksheet cluttered up with 0's).
Thanks again

No problem. Just killing time. ;-)

You can suppress display of zeros for any particular spreadsheet.

File: Options: Advanced

Go about half way down to Display Options For This Worksheet. Make sure the worksheet you want is selected in the dropdown. Uncheck the box for Show A Zero In Cells That Have A Zero Value.

Otherwise, if you want to do it by equations, change the first to be:
=IF(OR(D3=0,E3=0),"",D3*E3)

If you don't have negative numbers:
=IF(MIN(D3:E3)=0,"",D3*E3)
or
=IF(MIN(D3:E3)>0,D3*E3,"")

Or you could conditionally format any cells that have a zero value to have the same font and background color.

Lots of ways to do this. The first is preferable. Less moving parts. :-)

That did it ! I used first option. Funny I was in that dialogue before but did not notice the scroll bar to scroll down to this setting lol. thanks again for your help. I hope to be of some help to someone also sometime.
Cheers,
Al