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.

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.