hlookup
You would need ot add a new row which is 100-Mark
mark : 90 80 60 40 30 0
Nmark:10 20 40 60 80 90
grade A B C D E F
Then take the grade ans subtract from 100 and lookup in the Nmark row.
Mark
"tikchye_oldLearner57" wrote:
hi community
when i created a table horizontally, a value from Ascending scale...
example:
mark: 0 30 40 60 80 90
grade F E D C B A
and when I used the =hlookup to find the approximate mark say, 85, I able to
obtain "B"
however when I reverse the mark to Descending scale...
and use the same hlookup method with 85 I obtain an "F"
is there a way to find the correct grade if I place the mark in Descending
scale ??
thanks community for help render :)
--
oldLearner57
|