Excel if function with product formula

Question

I can't seem to find the right way of writing a formula for a cell. Purpose of the formula: showing the product of 2 cells if the result isn't zero, if it's zero, the cell should remain blank and not showing "0" formula so far:

=IF((L29*I29)=0;"";L29*I29)

Thanks :)

Answer 1

Use a custom format.

There are four sections to a cells format. Each defines how to display the value held in the cell dependent on what the value is.

(positive);(negative);(zero);(text)

I'd suggest the following which will display positives and negative numbers with two decimal places, zero values won't be shown, and any text as entered.

#,##0.00;-#,##0.00;;@  

Create or delete a custom number format

Answer 2

Try like this, it should work:

=IF(L29*I29=0;"";L29*I29)