Hidding the formula and limiting users

[Guest]

I have used excel to create marksheets that would generate results of "fail"
or "pass" for students. I noticed that for the cells without any input data,
the output of the cells with data still appear because the condtiton of the
formula was not met..
What can I do so that:
1 The formula will be invisible?
2 I would be able to copy the formula to any part of the list when I need it
without it necessarily appearing?
thanks
bimseun

 

[y_not]

If you go to the format command>security tab the option is there t
unlock & hide contents.

If you hide the contants of the cells (and protect the worksheet
nothing will show in the formula bar - is this what you're wanting