MS Excel Experts plz solve my problem

**syar** · 26th December 2012, 04:43 PM

There is another way to find PASS and Fail. Give it a try
L4

Code:

=IF(COUNTIF(D4:I4,"<32"),"Fail","Pass")

To find a Grade
In M4

Code:

=IF(L4="Fail","Fail",LOOKUP(K4,{90,80,60,50,40},{"A","B","C","D","Fail"}))

Note: AAp apna matloba result khod lekh lejeya ga, m n for example "ABCD" aur fail lekhain hain.

To find a class position
N4

Code:

=RANK(K4,$K$4:$K$37)

Hope this will help you. Custom formatting tu aap n kar le ha. agar phir bhe masla ho tu aap Apne sheet k HOME TAB--->Conditional Formattin--->Manage Rule m ja kar formula dekh sakte hain.

M n jo formula bataye hain ya alternate hain. Aap jo formula use kar rahe hain wo bhe theek hain. Aur akhre column m jo "If fail Subject Name" tu yahan p aap ko ak subject ka name darker ha k sab subject ka jis m fail ha.

regards

**Syed Hamid Ali** · 26th December 2012, 06:51 PM

Nhi brother. mujhy jo masail hain wo ye hain.
1. Position nikalni
2. GPA nikalna
3. Grade
4. % age
5. 70 to 79 tak ky number ko count kerna.
6. aur highlite kerna ky 70 to 79 marks waly.
mujhy aap ki help ki zaroorat hy. brother

**syar** · 26th December 2012, 07:45 PM

Syed Hamid Ali said:

Nhi brother. mujhy jo masail hain wo ye hain.
1. Position nikalni
2. GPA nikalna
3. Grade
4. % age
5. 70 to 79 tak ky number ko count kerna.
6. aur highlite kerna ky 70 to 79 marks waly.
mujhy aap ki help ki zaroorat hy. brother

Kya aap ko jo formula m n oper btaye hain wo aap n try keya? agar nahee tu apne matloba cell m formula enter kar k dekhain k result yahe chahte hain k nahee. highlight wala bad m dekhte hain. pahly aap formula try karain apne apne cell m.

regards

**Syed Hamid Ali** · 27th December 2012, 08:11 AM

Syar bhai aap ko post mujhy nazari nhi aai thi. sorry. main ny abhi dykhi hy. thanks. aap ny mery help ki. Allah aap ko jaza dy. Aameen
1 bat or bta dain. kia koi aysa faromula hy jis sy main ye count ker sakoon k 20 to 30 tak ky numbers ki tadad kitni hy. aur next cell main 35 to 50 ki counting ker dy. GPA or CGPA nikalny ka tareeqa kia hy? thanks.

**Syed Hamid Ali** · 28th December 2012, 06:05 PM

Syar brother plz i'm waiting ur reply. help for GPA and others in the last post. plz

**Haseeb Alamgir** · 28th December 2012, 06:13 PM

حامد بھائی اوپر جو جو فارمولے آپ کو بتائے ہیں
آپ ان کو اپنی فائل میں اپ ڈیٹ کرو
اور پھر چیک کرو
اور پھر اس اپ ڈیٹ کی ہوئی فائل کو اس جگہ شئیر کرو
تا کہ سید بھائی صرف وہ ہی کام اپ ڈیٹ کر کے آپ کو فائل
واپس شئیر کردیں

**Syed Hamid Ali** · 29th December 2012, 02:28 PM

main ny syar bhi ky formulas ko copy ker lia hy pehly sy bs iss main jo mazeed hy wo GPA or Count kerny ka tareeqa. Count iss tarha ky mujhy ye note kerna hy ky 10 to 30 number waly maslan 5 hain. Answer main bhi 5 aa jaye. aur next issi tarha 30 to 50 waly numbers count krny. thanks

**syar** · 30th December 2012, 12:06 AM

Syed Hamid Ali said:

main ny syar bhi ky formulas ko copy ker lia hy pehly sy bs iss main jo mazeed hy wo GPA or Count kerny ka tareeqa. Count iss tarha ky mujhy ye note kerna hy ky 10 to 30 number waly maslan 5 hain. Answer main bhi 5 aa jaye. aur next issi tarha 30 to 50 waly numbers count krny. thanks

Plz apne query explain karain k individual k number count karna chahte hain. k subject wise for example k math m kis n 10 tak aur kis n 30 tak no leye hain.

aap apne requirement k mutabiq sumifs ka function use kar sakte hain jis m greater or smaller then k operator sa madad le sakte hian. ya sumproduct k formula sa bhe le sakte hain aur <> k operator ko use Karin. aap try karian phr btaye ga.

regards

**Syed Hamid Ali** · 30th December 2012, 05:06 PM

For Example:
10 students hain. in main sy kuch ny 30 out of 100 liye. kuch ny 40 ksi ny 10 ksi ny 50 aur ksi ny 45. ab in count kerny hain k 10 to 20 numbers waly kitny hain. in main 30 to 35 waly kitny hain. issi tarha baqi sb.