On formula answer if a 0 (zero) answer, must be blank

Hi There,

I have the following formula in a cell that does a calculation.

=BI2*X2

If there is no values to calculate then it returns a 0 (zero) where I then need the cell to be blank.

How do I need to change the formula to leave the cell blank if the answer returned is zero?

Use Excel Options/Advanced/Display Options For This Worksheet and uncheck the 'Show a 0 in cells that have a 0 value' option.

As you can probably guess, this is set at a worksheet level.

This can also be done using Cell Formats or Conditional Formatting but the Options setting is the simplest.

Thank you to both posts as they both do the trick!

Will now mark the thread as solved!