Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Changing numbers/percentages to letter grades

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default Changing numbers/percentages to letter grades

You could use the LOOKUP function. Something like:

=LOOKUP(A6,{0,60,70,80,90},{"F","D","C","B","A"})

You can add more numbers/grades if you want to include + and - grades.

HTH,
Elkar


"Preston Steele" wrote:

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 772
Default Changing numbers/percentages to letter grades

here you go try this

=IF(A6="","",IF(A689,"A",IF(AND(A6<90,A679),"B", IF(AND(A6<80,A669),"C",IF(AND(A6<70,A659),"D",IF (A6<60,"F",""))))))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Preston Steele" wrote:

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Changing numbers/percentages to letter grades

Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

You could use the LOOKUP function. Something like:

=LOOKUP(A6,{0,60,70,80,90},{"F","D","C","B","A"})

You can add more numbers/grades if you want to include + and - grades.

HTH,
Elkar


"Preston Steele" wrote:

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 492
Default Changing numbers/percentages to letter grades

Try the LOOKUP function,
=IF(A1<0,LOOKUP(A1,{0,70,80,90},{"F","C","B","A"} ),"")
You can add/alter the figures and grades to suit. If A1 is empty, this will
return "" which is text. If you need to perform further calculations with
the result, change "" to zero (0),
Regards,
Alan.
"Preston Steele" <Preston wrote in message
...
I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get
a
cell that pulls from two other cells (50% for classroom, pulled from
another
worksheet and 50% for lab, also pulled from another worksheet, totaled in
A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do
I
do this?





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default Changing numbers/percentages to letter grades

If you had tried the formula first, before asking additional questions, you
would have discovered that it *does* work exactly as you wish.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Preston Steele" wrote in message
...
Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

You could use the LOOKUP function. Something like:

=LOOKUP(A6,{0,60,70,80,90},{"F","D","C","B","A"})

You can add more numbers/grades if you want to include + and - grades.

HTH,
Elkar


"Preston Steele" wrote:

I am trying to create several linked spreadsheets to form a grading
system
for class. I have most of the formulas down; however, I am trying to
get a
cell that pulls from two other cells (50% for classroom, pulled from
another
worksheet and 50% for lab, also pulled from another worksheet, totaled
in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How
do I
do this?


  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 492
Default Changing numbers/percentages to letter grades

Apologies Elkar,
I've just virtually duplicated your reply. It wasn't there when I posted
mine!,
Regards,
Alan.
"Alan" wrote in message
...
Try the LOOKUP function,
=IF(A1<0,LOOKUP(A1,{0,70,80,90},{"F","C","B","A"} ),"")
You can add/alter the figures and grades to suit. If A1 is empty, this
will return "" which is text. If you need to perform further calculations
with the result, change "" to zero (0),
Regards,
Alan.
"Preston Steele" <Preston wrote in
message ...
I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get
a
cell that pulls from two other cells (50% for classroom, pulled from
another
worksheet and 50% for lab, also pulled from another worksheet, totaled in
A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How
do I
do this?





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
Changing a value to a letter Lisa Excel Worksheet Functions 3 February 8th 06 07:31 PM
Changing a letter, to a number??? ncrowley Excel Discussion (Misc queries) 2 November 21st 05 04:25 PM
try to convert letter grades into GPA grade points scabbage Excel Worksheet Functions 3 October 22nd 05 05:31 AM
Converting Letter Grades to Numeric Angelo D Excel Worksheet Functions 6 April 25th 05 07:29 PM
Changing text from all caps to first letter cap Dave Excel Discussion (Misc queries) 2 February 18th 05 12:27 AM


All times are GMT +1. The time now is 11:35 AM.

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

About Us

"It's about Microsoft Excel"