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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies