Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F"))))))))))
If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
7 max nested if's. Use a workaround or better yet use LOOKUP. check help
index. -- Don Guillett SalesAid Software "VD" wrote in message ... =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
You can have only up to 7 IF's nesting levels in any formula Try instead =CHOOSE(MATCH(B3,{0;59;63;69;72;75;79;82;85;89;92} ,1),"F","D","D+","C-","C", "C+","B-","B","B-","A-","A") Arvi Laanemets "VD" wrote in message ... =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B37 5,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you so very,very much. I'm going to have to study up on the
Choose/Match concept. God knows i don't have a clue about what/how you did/did it, but Thanks -- VD, mistress in progress "Arvi Laanemets" wrote: Hi You can have only up to 7 IF's nesting levels in any formula Try instead =CHOOSE(MATCH(B3,{0;59;63;69;72;75;79;82;85;89;92} ,1),"F","D","D+","C-","C", "C+","B-","B","B-","A-","A") Arvi Laanemets "VD" wrote in message ... =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B37 5,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=LOOKUP(B3,{0,59,63,69,72,75,79,82,85,89,92},{"F", "D","D+","C-","C","C+","B-","B","B+","A-","A"})
"VD" wrote: =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
So, essentially you write the code backwards & the commas represent the
numbers in between? -- VD, mistress in progress "Teethless mama" wrote: =LOOKUP(B3,{0,59,63,69,72,75,79,82,85,89,92},{"F", "D","D+","C-","C","C+","B-","B","B+","A-","A"}) "VD" wrote: =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes,
BTW, I'm curious as to what a "mistress in progress" is. I can think of several answers. -- Don Guillett SalesAid Software "VD" wrote in message ... So, essentially you write the code backwards & the commas represent the numbers in between? -- VD, mistress in progress "Teethless mama" wrote: =LOOKUP(B3,{0,59,63,69,72,75,79,82,85,89,92},{"F", "D","D+","C-","C","C+","B-","B","B+","A-","A"}) "VD" wrote: =IF(B392,"A",IF(B389,"A-",IF(B385,"B+",IF(B382,"B",IF(B379,"B-",IF(B375,"C+",IF(B372,"C",IF(B369,"C-",IF(B363,"D+",IF(B359,"D","F")))))))))) If i take out the B363 & the B359 argument it works. -- VD, mistress in progress |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help With a Excel 2003 Formula | Excel Worksheet Functions | |||
Excel 2003 Formula cell reference colours (colors) | Setting up and Configuration of Excel | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel 2003 sum figures without formula | Excel Worksheet Functions | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions |