Try this in D1 and copy down............

=LOOKUP(C1,{0,32,50,75},{"Fail","Pass","Good","Exc ellent"})

Vaya con Dios,
Chuck, CABGx3




"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