Can someone please help me to know the formula in this sheet to calculate the Results (column C).
If the subject mark = 100%, then the Result will be 10%, which is the max Point a student can get
marks.jpg
Can someone please help me to know the formula in this sheet to calculate the Results (column C).
If the subject mark = 100%, then the Result will be 10%, which is the max Point a student can get
marks.jpg
Just divide B2 by 10:
=B2/10
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It’s not hard. In C5:
=B5/10
Drag copy down.
Please note that the reason you are dividing by 10 is because that is (100% / 10%), so if in future the 100% represents 20% (say) then you would be diving by (100 / 20), or 5.
Hope this helps.
Pete
Thanks fir the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks