Hide a formula result until cell has been filled

S

Sammy

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.
 
P

Peo Sjoblom

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
 
D

Dave Peterson

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,"")
 
R

RagDyeR

Try this:

=IF(C3,40-C3-0.2,"")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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.
 
S

Sammy

Thank you, that helped me out :D

Peo Sjoblom said:
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
Click to expand...
 
S

Sammy

Thank you.

Dave Peterson said:
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,"")
Click to expand...
 
H

Higgy

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
 
G

Gord Dibben

=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
 
H

Higgy

That did it! Thanks!

Gord Dibben said:
=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
Click to expand...
 
Top