ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sum=d11+c13 but hide result untill c13 value is entered (https://www.excelbanter.com/excel-discussion-misc-queries/252863-sum%3Dd11-c13-but-hide-result-untill-c13-value-entered.html)

New User

sum=d11+c13 but hide result untill c13 value is entered
 
sum=d11+c13 but hide result untill c13 value is entered



Roger Govier[_3_]

sum=d11+c13 but hide result untill c13 value is entered
 
Hi
=IF(C13="","",D11+C13)

--
Regards
Roger Govier

"New User" <New wrote in message
...
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




__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com




Joe User[_2_]

sum=d11+c13 but hide result untill c13 value is entered
 
"New User" <New wrote:
sum=d11+c13 but hide result untill c13 value is entered


=IF(C13="", "", D11+C13)

If you want to wait until both D11 and C13 have values, then:

=IF(COUNT(D11,C13)=2, D11+C13, "")


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com