Hi Everyone!

I have the following formula in Cell B1

=IF(A1=0," ")

Unfortunately this returns either a blank cell (for those that have a zero in it) which is perfect, but if it has anything else, it returns FALSE. And I want cell B1 to return cell A1's contents, unless its a zero, then it returns blank.

Any assistance?

Thank you in advance!