Hi Steve,
i tried this but ot did not work. This is the function I used.
==IF(AND(B7="",H7="",I7="",J7="" ),"",IF(J789,"A1",
IF(J779,"A2",IF(J769,"B3",IF(J765,"B4",IF(J759 ,"C5",IF(J754,"C6",IF(J752,"D7",IF(J749,"E8","U "))))))))

It return error message for my formula at IF(J749,"E8","U"))))))))
Is there anythong I have done worng? I have fut the function in the cell
with the formula.
regards,
Dipo


"bimseun" wrote:

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