Forum Discussion

Scooby-77's avatar
Scooby-77
Copper Contributor
Jan 29, 2019

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 to be blank until the primary cell has a value entered. Trying to avoid a zero from showing in the reference until the primary cell is updated with actual value. Any ideas?
Formulas and Functions

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 29, 2019

    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.

    • Scooby-77's avatar
      Scooby-77
      Copper Contributor
      Jan 29, 2019
      Perfect! I knew it was something in my writing...one simple character can change it all! Thanks

Resources