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

  • Thread starter Thread starter New User
  • Start date Start date
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
 
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, "")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuing Formula - try 3 1
Stumped on adding 3 cells 2
Partial input 4
sum a column within a name definition 7
Formula omits adjacent cells error message 4
Create a conditional formula to change the value of other cells 1
Hide zero values 2
Conditional sum, when condition has multiple values 3

Back
Top