IF formula issue with blank cell

%3CLINGO-SUB%20id%3D%22lingo-sub-327334%22%20slang%3D%22en-US%22%3EIF%20formula%20issue%20with%20blank%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327334%22%20slang%3D%22en-US%22%3EI%20am%20creating%20spreadsheet%20of%20data%20and%20referencing%20on%20another%20tab%20within%20the%20same%20worksheet.%20The%20primary%20cell%20is%20blank%20until%20updated%20with%20a%20value...so%20I%20am%20trying%20to%20figure%20out%20how%20to%20write%20the%20formula%20to%20be%20blank%20until%20the%20primary%20cell%20has%20a%20value%20entered.%20Trying%20to%20avoid%20a%20zero%20from%20showing%20in%20the%20reference%20until%20the%20primary%20cell%20is%20updated%20with%20actual%20value.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327364%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20issue%20with%20blank%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327364%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327361%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20issue%20with%20blank%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327361%22%20slang%3D%22en-US%22%3EPerfect!%20I%20knew%20it%20was%20something%20in%20my%20writing...one%20simple%20character%20can%20change%20it%20all!%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327352%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20issue%20with%20blank%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327352%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20use%20something%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%3D%22%22%2C%22%22%2CA1)%3C%2FPRE%3E%0A%3CP%3EHowever%20it%20return%20text%20and%20if%20you%20do%20some%20calculations%20on%20these%20cells%20you%20may%20receive%20an%20error.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%20you%20may%20disable%20this%20setting%20for%20the%20sheet%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20549px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71348iB59060062DD032B5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20option%20is%20to%20hide%20zeroes%20with%20conditional%20formatting.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
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?
3 Replies
Highlighted

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

image.png

 

Another option is to hide zeroes with conditional formatting.

Highlighted
Perfect! I knew it was something in my writing...one simple character can change it all! Thanks

You are welcome