=IF(A1=75,"Excellent",IF(A1=50,"Good",IF(A1=32, "Pass","Fail")))

"vlook fomula" wrote:

Example


TOTAL MARKS MARKS OBTAIN REMARKS

CAT 100 50 ?
JHON 100 65
PETER 100 75
PETERSON 100 90
SUNNY 100 45
DENNY 100 33
DOLLY 100 5
CRIST 100 45


GREATER 75 THAN OR EQUAL = EXCELLENT
LESS 75 THEN AND GREATER 50 = GOOD
LESS 50 THEN AND GREATER 32 = PASS
LESS 33 = FAIL

Kindly help me i want to show excellent, good, fail and good with the fomula
in remarks coloumn. i really thanks full to pete and mike for previous help
in colour fomula. got sucess

thanks regards
zafar