Home

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
Scooby-77
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

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.

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

You are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies