R Roger Govier Jan 9, 2010 #2 Hi =IF(C13="","",D11+C13) -- Regards Roger Govier New User said: sum=d11+c13 but hide result untill c13 value is entered __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com
Hi =IF(C13="","",D11+C13) -- Regards Roger Govier New User said: sum=d11+c13 but hide result untill c13 value is entered __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com
J Joe User Jan 9, 2010 #3 New User said: sum=d11+c13 but hide result untill c13 value is entered Click to expand... =IF(C13="", "", D11+C13) If you want to wait until both D11 and C13 have values, then: =IF(COUNT(D11,C13)=2, D11+C13, "")
New User said: sum=d11+c13 but hide result untill c13 value is entered Click to expand... =IF(C13="", "", D11+C13) If you want to wait until both D11 and C13 have values, then: =IF(COUNT(D11,C13)=2, D11+C13, "")
