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