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!
Bookmarks