| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Linear Mode
