I've always wondered... isn't there a shortened way to achieve the same goal as the following?
=IF(x=0,"",x)
(Assume x is a long, complicated formula).

If the value of the calculation is not 0, it really seems unnecessary to calculate it again. I realise I could do the initial calculation in a separate cell, then just use that value again, but I was just wondering if there's another formula or IF syntax that will accomplish the same thing in a single cell.

Thanks in advance!