Subject Out of Marks Obtained Marks
Marathi 100 64
Hindi 100 62
English 100 48
Mathematics 150 52
Science 100 49
Social Science 100 55
Best of Five 500 278
Which obtained marks is minimum based on out of marks.
In Excel How to Caculate such type of minimum.
This question is out of my area of expertise, but I think to get the answer you would divide each "Obtained Marks" by its "Out of Marks" and multiply by 100 to get the "percentage grade" (set up a column for this)... I would think the smallest percentage grade (apply MIN function to the column I suggested you add) would qualify as your "minimum".
Why would you start the same thread when I already gave a solution here http://www.excelfox.com/forum/f2/fin...ormalized-865/
And Rick, yes that's exactly what I've done with the formula.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks