The fast one was incorrect. Plz find out new one. But result always same in every cell. There are no matter what is value of it. Result always following the fast statment that i chose it display in "Best". Plz solve my problem with formula or provide me another alternative what is easiest way in this work place.
In "C" Colum is percentage or mark. B2*100/ full mark 600
Why should we need percentage? Because need a short data not a 200,300,367marks of data. So there for we convert marks in % . After convert to % we need It's division like 1st,2nd,3rd. So we want that if a boy gets 500marks then it's percentage is 500*100/Fullmark 600 then it is 82%mark. Now it is the question is how could we put a formula that this boys mark display Best ? And other one Good and Poor/Fall.
Plz provide It's easiest way in Ms Excel.
That formula was remember by me but not now !
Bicky Das, email@example.com