Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default sum=d11+c13 but hide result untill c13 value is entered

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 905
Default 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, "")
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup untill a vaule is found then automaticaly paste the result Aposto Excel Worksheet Functions 1 April 30th 08 04:42 PM
Hide formula result values until all components are entered Maria Excel Discussion (Misc queries) 3 September 18th 06 02:01 PM
How do i hide a solution until data is entered Dean Excel Worksheet Functions 2 February 9th 06 12:28 AM
how do i hide value errors until data can be entered? cath_cw Excel Worksheet Functions 0 April 26th 05 05:58 PM
How to hide values in a running balance untill new data is entere. doggydog Excel Discussion (Misc queries) 1 March 9th 05 05:58 AM


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"