View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vlook fomula vlook fomula is offline
external usenet poster
 
Posts: 43
Default Need help about logical formula

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