pls grade ka fourumla laga dy koi bhai. meherbani ho gigarding key bhi hai us k according plssssssssssssss
283167
pls grade ka fourumla laga dy koi bhai. meherbani ho gigarding key bhi hai us k according plssssssssssssss
283167
Mera Peghaam Mohabbat hai jahan tak pohanchy
[FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]
Nice
salam;;
in cell I15 just type
and copy down as far as required. change critera as requiredCode:=LOOKUP(H15,{0,40,50,60,70,80,88},{"f","d","c","c+","b","b+","a","a+"})
replace the above formula with this one
Code:=LOOKUP(H15,{0,40,50,60,70,80,88},{"d","c","c+","b","b+","a","a+"})
میں نے کوشش کی تھی کے آپ خود فارمولا پُٹ کریں
مگر شائد آپ سے نہ ہو سکا آپ کی شیٹ میں فارمولا پُٹ کر دیا ہے
چیک کریں
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"))))))
Bookmarks