| Home |
| Search |
| Today's Posts |
|
#1
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
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 ... 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
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
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
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 ... 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
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
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Thank you, that helped me out :D
"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 ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Cheers :D
"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
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 ... 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. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
Much appreciated :D
"via135" wrote: 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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
I am working with a spreadsheet and would like to do the same. How would this
work for the formula =C6 or Formula =C6+30 Thanks "Sammy" wrote: Much appreciated :D "via135" wrote: 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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
=IF(C6="","",C6)
=IF(C6="","",C6+30) What the formula does is return a blank-looking cell if C6 has no data, otherwise return the calculated value. Gord Dibben MS Excel MVP On Tue, 19 May 2009 11:29:01 -0700, Higgy wrote: I am working with a spreadsheet and would like to do the same. How would this work for the formula =C6 or Formula =C6+30 Thanks "Sammy" wrote: Much appreciated :D "via135" wrote: 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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide a formula result until cell has been filled
That did it! Thanks!
"Gord Dibben" wrote: =IF(C6="","",C6) =IF(C6="","",C6+30) What the formula does is return a blank-looking cell if C6 has no data, otherwise return the calculated value. Gord Dibben MS Excel MVP On Tue, 19 May 2009 11:29:01 -0700, Higgy wrote: I am working with a spreadsheet and would like to do the same. How would this work for the formula =C6 or Formula =C6+30 Thanks "Sammy" wrote: Much appreciated :D "via135" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
| Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Linear Mode
