Formating cell
I have used Excel to set up a mark sheet thus:
Name
Mark Grade Remarks
Mr x 80 1 Distinction
Mr y 30 9 Fail
Mr z 65 3 Credit
9 Fail
9 Fail
9 Fail
When I do not have names beyond Mr z, the columns for grade and remarks
continue to output "9" and "fail". I used the IF function in the formula used
for grade and remarks.
What can I do so that
First, the name, grade and remark column would remain EMPTY except when
names and marks are typed in?
Second, since this file is shared by may users, how can I hide the formula
with a passwprd, but the users can have access to name and marks colun.
cheers,
bimseun
|