Ticket Options
Question Profile
| DATE | Sep 9, 1998 |
| TICKET | #307072 |
| STATUS | Closed |
| SUBJECT | |
| CAT | |
| TYPE | |
| DESC | |
| DESC | |
| PLATFORM | |
| MODEL | |
| PROC | |
| RAM | |
| DRIVE | |
| NAME | |
| USERNAME | |
| TECHNICAL | |
| ISSUE |
Question Details
TICKET ARCHIVE -> Excel Formula
No Wonder User - Sep 9, 1998 - 2:01 am
Knowledge Level: Expert but stumped
Problem: Software
Computer Type: Apple
Model: Performa 6400/20
RAM: 65+
RAM Enhancer: None
OS Version: MacOS 8.1
Description:
Hello MacHome!
I'm trying to write a simple formula in MS Office Excel 98 for the Macintosh to figure out grades for my students (from a total of 350 possible points). I have enclosed it below. Excel keeps claiming there is a problem with it and I literally have spents hours going over it and not finding anything wrong with it. I keep getting an error in the formula. It doesn't seem to want to calculate the "D" grades for the formula! I have checked the parenthesis and structure of the function. I know there is a limit to the number of nested "If's" it will handle, but I don't believe I have exceeded it. This simple formula would help my fellow instructors. I know there is a simple solution, but I can seem to find it! Please tell me what's wrong!
=IF(M5>318,"A",IF(M5>307,"A-",IF(M5>293,"B+",IF(M5>276,"B",IF(M5>265,"B-",IF(M5>254,"C+",IF(M5>240,"C",IF(M5>229,"C-",IF(M5>215,"D","F")))))))))
Send Attachments? Yes
Problem: Software
Computer Type: Apple
Model: Performa 6400/20
RAM: 65+
RAM Enhancer: None
OS Version: MacOS 8.1
Description:
Hello MacHome!
I'm trying to write a simple formula in MS Office Excel 98 for the Macintosh to figure out grades for my students (from a total of 350 possible points). I have enclosed it below. Excel keeps claiming there is a problem with it and I literally have spents hours going over it and not finding anything wrong with it. I keep getting an error in the formula. It doesn't seem to want to calculate the "D" grades for the formula! I have checked the parenthesis and structure of the function. I know there is a limit to the number of nested "If's" it will handle, but I don't believe I have exceeded it. This simple formula would help my fellow instructors. I know there is a simple solution, but I can seem to find it! Please tell me what's wrong!
=IF(M5>318,"A",IF(M5>307,"A-",IF(M5>293,"B+",IF(M5>276,"B",IF(M5>265,"B-",IF(M5>254,"C+",IF(M5>240,"C",IF(M5>229,"C-",IF(M5>215,"D","F")))))))))
Send Attachments? Yes
No Wonder Tech - Sep 9, 1998 - 8:38 am
William,
Hi, my name is Ed. I'm a No Wonder volunteer and will try to answer your question. My email address is
I wouldn't call myself an Excel expert, but I do see a logical (i.e., not specifically Excel) flaw in this formula.
Take the first two IF statements (to select between A and A-). The first says to assign an A if grade is more than 318. The second one says to assign an A- if grade is more than 307. Suppose the grade is 319. Then both the first and second IF statements are correct and the program doesn't know whether to assign an A or A-.
Suggest you formulate your IF statements in terms of ranges, i.e., M5 larger than 318, M5 between 317 and 307, etc.
Good luck,
ed
Hi, my name is Ed. I'm a No Wonder volunteer and will try to answer your question. My email address is
I wouldn't call myself an Excel expert, but I do see a logical (i.e., not specifically Excel) flaw in this formula.
Take the first two IF statements (to select between A and A-). The first says to assign an A if grade is more than 318. The second one says to assign an A- if grade is more than 307. Suppose the grade is 319. Then both the first and second IF statements are correct and the program doesn't know whether to assign an A or A-.
Suggest you formulate your IF statements in terms of ranges, i.e., M5 larger than 318, M5 between 317 and 307, etc.
Good luck,
ed
IF THIS IS YOUR QUESTION AND YOU WISH TO RESPOND, LOGIN HERE FIRST.
