| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find avg, min & max for grading subject
Hi, with help from Mr.Ardus Peter, sjoblom & philips, I manage to get some
information about formula for grading. But I still having problem. my grades all at cell e.g A2:A35. (beside I enter grade A,B,C,D,E there is also simbol "-" and "x".('-' for not taking the subject and 'x' for absent) I try this: Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0)) Max: =CHAR(MIN(CODE(A2:A35))) work fine. But when i enter simbol "-" or "x" it show #value. Pls help me how to overcome this problem. TQ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Threaded Mode
