|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2006, 08:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Hide a formula result until cell has been filled
Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2)
& I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help. 
|
|
#2
May 20th, 2006, 08:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Try
=(40-C3-0.2)*(C3"") which will show zero until there is a value in C3 or =IF(C3="","",40-C3-0.2) which will show blank -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Sammy" wrote in message news  Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help.
|
|
#3
May 20th, 2006, 08:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
You can make that cell look empty with a formula like:
=if(c3="","",40-C3-0.2) Or you could even add a little validity check: =if(isnumber(c3),40-C3-0.2,"") Sammy wrote: Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help. -- Dave Peterson
|
|
#4
May 20th, 2006, 08:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
How about =IF(C3="","",40-C3-0.2) -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=543995
|
|
#5
May 20th, 2006, 08:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Try this:
=IF(C3,40-C3-0.2,"") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sammy" wrote in message news
Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2)& I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help.
|
|
#6
May 20th, 2006, 08:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
hi! =IF(C3="","",40-C3-0.2) -via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=543995
|
|
#7
May 20th, 2006, 10:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Thank you.
"Dave Peterson" wrote: You can make that cell look empty with a formula like: =if(c3="","",40-C3-0.2) Or you could even add a little validity check: =if(isnumber(c3),40-C3-0.2,"") Sammy wrote: Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help. -- Dave Peterson
|
|
#8
May 20th, 2006, 10:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Thank you, that helped me out
"Peo Sjoblom" wrote: Try =(40-C3-0.2)*(C3"") which will show zero until there is a value in C3 or =IF(C3="","",40-C3-0.2) which will show blank -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Sammy" wrote in message news Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2) & I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help.
|
|
#9
May 20th, 2006, 10:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Cheers
"LACA" wrote: How about =IF(C3="","",40-C3-0.2) -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=543995
|
|
#10
May 20th, 2006, 10:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Thank you very much.
"RagDyeR" wrote: Try this: =IF(C3,40-C3-0.2,"") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sammy" wrote in message news
Hello, I'm new to excel, I'm trying a simple formula (=40-C3-0.2)& I'm wondering if it is possible to hide the result of my formula until I had added an amount into cell C3, as it results in showing 39.8 until imput another number into C3, I would like the result to remain blank until I put a number in C3. Thanks for any help.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| My formula returns a result but the cell displays a zero? | Excel User | Worksheet Functions | 14 | July 17th, 2008 08:49 PM |
| Currency to Text | mytipi | Worksheet Functions | 1 | February 21st, 2006 11:43 PM |
| VBA | Monty | Worksheet Functions | 2 | January 30th, 2006 01:37 PM |
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | o0o0o0o | Worksheet Functions | 6 | November 19th, 2004 03:13 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Linear Mode
