Why doesn't excel 2003 accept this "IF" grade formula?? Please HE
 

=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

Why doesn't excel 2003 accept this "IF" grade formula?? Please HE
 

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

Why doesn't excel 2003 accept this "IF" grade formula?? Please HE
 

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

Why doesn't excel 2003 accept this "IF" grade formula?? Pleas
 

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

Why doesn't excel 2003 accept this "IF" grade formula?? Please HE
 

=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

Why doesn't excel 2003 accept this "IF" grade formula?? Pleas
 

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

Why doesn't excel 2003 accept this "IF" grade formula?? Pleas
 

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