|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 26th, 2009, 08:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula help
I'm trying to update assessment excel sheet of my college. I tried the
following formula for grades in 2007 excel and it worked fine. but the same formula returns an error in 2003 excel. does anyone have a solution to this? Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F","")))))))))) 
|
|
#2
April 26th, 2009, 08:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
Let us know whether if it is an error OR returning wrong answers.
If returning wrong answers check the cell format of L11. Change that to General if not. If it is an error make sure you have copied the formula right.. If this post helps click Yes --------------- Jacob Skaria "sam8" wrote: I'm trying to update assessment excel sheet of my college. I tried the following formula for grades in 2007 excel and it worked fine. but the same formula returns an error in 2003 excel. does anyone have a solution to this? Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F",""))))))))))
|
|
#3
April 26th, 2009, 08:52 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
You can also achieve this using LOOKUP() funciton which makes the formula
shorter and easy to modify.... =LOOKUP(B21,{0,54,55,60,67,70,73,76,80,85,90},{"F" ,"F","D","C-","C","C+","B-","B","B+","A-","A"}) If this post helps click Yes --------------- Jacob Skaria "sam8" wrote: I'm trying to update assessment excel sheet of my college. I tried the following formula for grades in 2007 excel and it worked fine. but the same formula returns an error in 2003 excel. does anyone have a solution to this? Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F",""))))))))))
|
|
#4
April 26th, 2009, 09:37 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
Wonderful! Great help indeed Mr Jacob.
It worked well. But still I don't understand why the previous formula didn't work. I copied correctly but it was returning error message. As I typed the formula and came upto "D" and "F" the font color of L11 turned black instead of the selected light blue color. Error message: THE FORMULA YOU TYPED CONTAINS AN ERROR Thanks a lot Jacob Skaria wrote: You can also achieve this using LOOKUP() funciton which makes the formula shorter and easy to modify.... =LOOKUP(B21,{0,54,55,60,67,70,73,76,80,85,90},{"F ","F","D","C-","C","C+","B-","B","B+","A-","A"}) If this post helps click Yes --------------- Jacob Skaria I'm trying to update assessment excel sheet of my college. I tried the following formula for grades in 2007 excel and it worked fine. but the same formula returns an error in 2003 excel. does anyone have a solution to this? Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F",""))))))))))
|
|
#5
April 26th, 2009, 10:07 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
Hello,
... But still I don't understand why the previous formula didn't work. ... Too many nested IF's. 7 is max. Regards, Bernd
|
|
#6
April 26th, 2009, 10:14 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
2003 do not allow more than seven IF conditions...Go for an alternate..
If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Let us know whether if it is an error OR returning wrong answers. If returning wrong answers check the cell format of L11. Change that to General if not. If it is an error make sure you have copied the formula right.. If this post helps click Yes --------------- Jacob Skaria "sam8" wrote: I'm trying to update assessment excel sheet of my college. I tried the following formula for grades in 2007 excel and it worked fine. but the same formula returns an error in 2003 excel. does anyone have a solution to this? Formula: =IF(L11=90,"A",IF(L11=85,"A-",IF(L11=80,"B+",IF(L11=76,"B",IF (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F",""))))))))))
|
|
#7
April 26th, 2009, 11:25 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
Thank you very much.
Samuel Jacob Skaria wrote: 2003 do not allow more than seven IF conditions...Go for an alternate.. If this post helps click Yes --------------- Jacob Skaria Let us know whether if it is an error OR returning wrong answers. [quoted text clipped - 12 lines] (L11=73,"B-",IF(L11=70,"C+",IF(L11=67,"C",IF(L11=60,"C-",IF(L11=55,"D", IF(L11=54,"F",""))))))))))
|
|
#8
April 26th, 2009, 11:26 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help
Hi Mr Bernd,
Thank you very much Samuel Bernd P wrote: Hello, ... But still I don't understand why the previous formula didn't work. ... Too many nested IF's. 7 is max. Regards, Bernd
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
