Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |