exal per Grade ka fourmala

**meerabkhan** · 12th March 2011, 06:57 PM

pls grade ka fourumla laga dy koi bhai. meherbani ho gigarding key bhi hai us k according plssssssssssssss
283167

**IT.BOY** · 12th March 2011, 07:14 PM

آپ یہ تھریڈ دیکھیں اس طرح آپ خود بھی سیکھ جائیں گی

Check Thread

**Mawara** · 12th March 2011, 09:10 PM

IT.BOY said:

آپ یہ تھریڈ دیکھیں اس طرح آپ خود بھی سیکھ جائیں گی

Check Thread

Thank u IT.BOY

**GeniousBoy** · 12th March 2011, 10:21 PM

Nice

**syar** · 12th March 2011, 10:21 PM

salam;;

in cell I15 just type

Code:

=LOOKUP(H15,{0,40,50,60,70,80,88},{"f","d","c","c+","b","b+","a","a+"})

and copy down as far as required. change critera as required

**meerabkhan** · 13th March 2011, 01:54 PM

[FONT="Garamond"][COLOR="DeepSkyBlue"][SIZE="5"][B]

syar said:

salam;;

in cell I15 just type

Code:

=LOOKUP(H15,{0,40,50,60,70,80,88},{"f","d","c","c+","b","b+","a","a+"})

and copy down as far as required. change critera as required

BHAI FOURMAL TU LAG GAYA LAKIN SAHI NAHI 6O PER b GRADE HONA CHAEE LAKIN C+ DY RAOHA HAI ISI TRHA PLS HELP

**syar** · 13th March 2011, 04:39 PM

replace the above formula with this one

Code:

=LOOKUP(H15,{0,40,50,60,70,80,88},{"d","c","c+","b","b+","a","a+"})

**IT.BOY** · 13th March 2011, 06:59 PM

میں نے کوشش کی تھی کے آپ خود فارمولا پُٹ کریں
مگر شائد آپ سے نہ ہو سکا آپ کی شیٹ میں فارمولا پُٹ کر دیا ہے
چیک کریں

Code:

=if(h15>88,"a+",if(h15>80,"a",if(h15>70,"b+",if(h15>60,"b",if(h15>50,"c+",if(h15>40,"c","d"))))))

Thread: exal per Grade ka fourmala