| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Analizing Grades
I have been asked to compare estmated and actual student grades. As in - if a
student was predicted a B and received a C or A etc. can I show this step (i.e. -1 or 1 grades out). Have put in an IF function (=IF(E9=F9,"OK","Not OK") and I am wondering if I can say "if Not Ok the grade was out by -1,-2, 2, 3 etc. Hope that makes sense..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
