Hi there,
I am having difficulties writing the formulas to update my students' grades. and I would highly appreciate if you can help me write the formula.
Please help to write formulas for Scale Grade ( using Decimal Grade) and Alpha Grade (using Scale Grade).
Thank you,Grades.xlsx
see the attached file - made some changes to your excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi
You can use lookup
See the file
Regard
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Re: Formula for students' grades.
Thank you very much.
Re: Formula for students' grades.
I would highly appreciate if you can help me more about some problems i have to face now. (You may remember the excel you made for me, please see attached file).
Can you help me with this?
1. In sheet 1(2), when I copy the formula from K2, the results remain unchanged. (cells that are in yellow).
2. And there is a mistake in sheet 2, (cell in yellow). It should be B, not B+ if we compare it with X18.
Grades.xlsx
Thank you!
Hi hope this helps, using array formulas (means when you apply the formula need to press CTRL+SHIFT+ENTER key/button all together
, not ENTER alone)
cheers
@kara
It is not a good idea to start a new question in the same thread. You will typically get less answers, and the other members will not profit from the help you receive.
If necessary, you can always add a link to your other thread
Re: Formula for students' grades.
@Pepe Le Mokko
Thank you for your comment. I got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks