Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VD VD is offline
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 99
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VD VD is offline
external usenet poster
 
Posts: 5
Default 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




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VD VD is offline
external usenet poster
 
Posts: 5
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help With a Excel 2003 Formula Bazza Excel Worksheet Functions 2 November 13th 06 11:21 PM
Excel 2003 Formula cell reference colours (colors) Clarkee Setting up and Configuration of Excel 4 November 10th 06 10:05 AM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Excel 2003 sum figures without formula PULIDOC Excel Worksheet Functions 2 April 28th 06 06:27 PM
Convert Excel 4 formula to Excel 2003 format The Gasell Excel Worksheet Functions 3 April 12th 06 05:07 PM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"