| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if command
I am a teacher in a school and due to the large amount of test we do and the subsequent analysis I was wondering if any on could help me out in this problem. All of our tests have different grade boundaries and as such I would like a easy to use if command. I tried the following but the problem occurs as it gives me a grade of D17 instead of the grade that the cll refers to. =IF(C8C$17,"D17",IF(C8C$18,"D18", IF(C8C$19,"D19",IF(C$2059,"D20","F")))) any help would be very grateful -- afromaniac ------------------------------------------------------------------------ afromaniac's Profile: http://www.officehelp.in/member.php?userid=5679 View this thread: http://www.officehelp.in/showthread.php?t=1310385 Posted from - http://www.officehelp.in |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Contol toolbox command button | Excel Discussion (Misc queries) | |||
| Command Buttons | Excel Discussion (Misc queries) | |||
| How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
| Help requested for an Excel Toolbar command | Excel Discussion (Misc queries) | |||
| command button in excel will move when print. | Excel Discussion (Misc queries) | |||
Threaded Mode
