N Naas Mar 24, 2004 #1 got the following text in cells that I want to hide; FALSE , #div/0! How do I do it? Thanks
F Frank Kabel Mar 24, 2004 #2 Hi you may post your formulas which you're currently using. Best way to add some error checking to them
Hi you may post your formulas which you're currently using. Best way to add some error checking to them
J JE McGimpsey Mar 24, 2004 #3 If FALSE is being generated by an if statement for which you haven't provided a False option: =IF(<criterion>, true option) Then use =IF(<criterion>, true option, "") For #DIV/0, check the denominator first: =IF(B1=0,"",A1/B1)
If FALSE is being generated by an if statement for which you haven't provided a False option: =IF(<criterion>, true option) Then use =IF(<criterion>, true option, "") For #DIV/0, check the denominator first: =IF(B1=0,"",A1/B1)