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.