Calculate Minimum Value Based On Percentage When Denominator Is Different

[lokvan]

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.

[Rick Rothstein]

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".

[Excel Fox]

Why would you start the same thread when I already gave a solution here http://www.excelfox.com/forum/f2/find-minimum-value-after-data-normalized-865/

And Rick, yes that's exactly what I've done with the formula.