Hide a formula result until cell has been filled

[Guest]

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.

 

[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

 

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

 

[LACA]

How about

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

 

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

 

[via135]

hi!

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

-via135

 

[Guest]

Thank you, that helped me out

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

 

[Guest]

Thank you.

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

 

[Guest]

Cheers

 

[Guest]

Thank you very much.

 

[Guest]

Much appreciated

 

[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

 

[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

 

[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

 

[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

 

[Higgy]

That did it! Thanks!

=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

 

[Higgy]

That did it! Thanks!

=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