SOLVED
Home

Hide formulas until there is a value

%3CLINGO-SUB%20id%3D%22lingo-sub-328757%22%20slang%3D%22en-US%22%3EHide%20formulas%20until%20there%20is%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328757%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20that%20tracks%20accounting%20information.%20I%20am%20leaving%20the%20company%20soon%2C%20so%20I%20am%20setting%20up%20the%20file%20for%20all%20of%202019.%20The%20file%20is%20split%20out%20to%20monthly%20and%20quarterly%20results.%20I%20have%20input%20formulas%20for%20averages%20for%20the%20quarter%20for%20the%20first%20quarter.%20I%20want%20to%20have%20the%20formula%20there%20so%20that%20the%20person%20who%20takes%20over%20the%20file%20after%20I%20am%20gone%20already%20has%20the%20formula%20ready%20to%20go.%20However%20because%20the%20year%20is%20still%20new%20all%20I%20currently%20have%20are%20zeros%20for%20the%20monthly%20results.%20So%20I%20get%20a%20return%20error%20%23DIV%2F0!%20I%20need%20to%20leave%20the%20formula%20in%20the%20cell%2C%20however%20I%20want%20to%20hide%20the%20result%20until%20there%20is%20an%20actual%20number%20result%20(sometimes%20the%20result%20is%20a%20negative%20number).%20Is%20there%20a%20way%20to%20leave%20the%20formula%20in%20the%20cell%20but%20have%20it%20hidden%20in%20the%20cell%20until%20there%20is%20a%20result%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328814%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20formulas%20until%20there%20is%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328814%22%20slang%3D%22en-US%22%3E%3CP%3EPerfect%20that%20works%20for%20what%20I%20need%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328796%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20formulas%20until%20there%20is%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328796%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20variant%20you%20may%20wrap%20your%20formulas%20like%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(%26lt%3Byour%20formula%26gt%3B%2C%22%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
pan_pacmeg927
New Contributor

I have an excel file that tracks accounting information. I am leaving the company soon, so I am setting up the file for all of 2019. The file is split out to monthly and quarterly results. I have input formulas for averages for the quarter for the first quarter. I want to have the formula there so that the person who takes over the file after I am gone already has the formula ready to go. However because the year is still new all I currently have are zeros for the monthly results. So I get a return error #DIV/0! I need to leave the formula in the cell, however I want to hide the result until there is an actual number result (sometimes the result is a negative number). Is there a way to leave the formula in the cell but have it hidden in the cell until there is a result? 

2 Replies
Solution

As variant you may wrap your formulas like

=IFERROR(<your formula>,"")

Perfect that works for what I need, thank you!

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