Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help about logical formula
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help about logical formula
=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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help about logical formula
=IF(C2=75,"EXCELLENT",IF(C2=50,"GOOD",IF(C2=32, "PASS","FAIL")))
Regards, Stefi €˛vlook fomula€¯ ezt Ć*rta: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Including a range of number in a IF (Logical Test) formula | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Need help with a dynamic lookup and logical formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |