Forum Discussion
IF formula issue with blank cell
I am creating spreadsheet of data and referencing on another tab within the same worksheet. The primary cell is blank until updated with a value...so I am trying to figure out how to write the formula...
You may use something like
=IF(A1="","",A1)
However it return text and if you do some calculations on these cells you may receive an error.
Also you may disable this setting for the sheet
Another option is to hide zeroes with conditional formatting.
Perfect! I knew it was something in my writing...one simple character can change it all! Thanks
You are welcome