A Addil Ahmed Dec 19, 2014 #1 how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty .
how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty .
C Claus Busch Dec 19, 2014 #2 Hi, Am Fri, 19 Dec 2014 01:35:46 -0800 (PST) schrieb Addil Ahmed: how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty . Click to expand... please post your formula Regards Claus B.
Hi, Am Fri, 19 Dec 2014 01:35:46 -0800 (PST) schrieb Addil Ahmed: how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty . Click to expand... please post your formula Regards Claus B.
A Alex Plantema Dec 19, 2014 #3 Addil Ahmed schreef in how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty . Click to expand... =IF(A1="","",A1) or use the setting to hide zeros.
Addil Ahmed schreef in how to show a blank in cell ,instead of "0" value if referring to another sheet or cell /which is empty . Click to expand... =IF(A1="","",A1) or use the setting to hide zeros.
