MS EXCEL main Result Tayar Karna .....

**Mubashir Aziz** · 5th June 2009, 02:48 PM

Thanks khusi, Imujij, Rashid, Shahzad and Shabab ……..

@ Imjuji, IT Froums par kissi nay farmaish key to main nay ussay sheet tayar kar kay di thi … leekan baad main main nay iss main mazeed improvements key ….. agar koi seekhna chahta hay to main step by step bhi samjha doon ga … leekan I think there are few persons who want to learn excel so i thought its useless to give explanation of every step ...... ….

One thing also yaar it looks very hard to write in Roman urdu so it will definitely time consuming thing for me so InshaAllah soon Step by Step I’ll tell you but first in English …… Hope you won’t mind .

**Mubashir Aziz** · 5th June 2009, 03:32 PM

In attached image I have 6 column from A to G.
Column A contains Students Names
Column B to F contains Subjects and below their marks
Column G have condition that if Student have less than 60 marks in any subject
He will be considered as Fail
If he is passed in All subject then Pass Will appear.

Ok now I'll try to write in roman urdu …..

Fail Aur Pass kay liye aap hamaisha if condition use kartay hoon gay aur buhat ziyda khawar hotay hoon ga
Aaj Sub Say Pahlay main aap ko Countif() kay function kay baray main batoon ga ka kiss tarah hum issay use karain gay

G4=IF(COUNTIF(B2:F2,">59")=5,"Pass","Fail") (yah complete formula hay main iss kay part kar kay aap ko baton ga )

G4=IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS","F AIL") yah bhi aap ko wohi result day ga jo main nay oper walay formula say hasil kia hay …. Try this also …..

Aap sirf iss formulay par ghour karain …

=COUNTIF(B2:F2,">59")
Result : 4
Syntax
=countif("Range Matlah Kiss area main say value daikhni hay","Kia Criteria Hona Chahiye")
Range : B2:F2
Criteria : ">59" Mean 59 number say ziyada honay chahye …. Aap idhar sirf 60 likhain gay to
Answer 3 aai ga keonkah 60 three times appear ho raha hay
=COUNTIF(B2:F2,60)
Result : 3

Aap pahlay countif key practice karain takh yah aap ko clear ho jay.
keep in mind then any condition e.g. > or < or >= ko hum hamisha " " kay under use karain gay ……..

PS: Mujhay lazmi bataiye ga kah meri pahli kawish kaisi lagi aap ko ....... and keep in mind "Practice Always Makes a Man Perfect"

Sorry agar aap ko meri roman urdu key samjh na aai ho .... feel free to contact me in case of any confusion .....

**bhai looG** · 22nd June 2009, 03:46 PM

zaberdast yaara

**SHAHZAD58** · 22nd June 2009, 04:25 PM

plz help me........meri boht hi karamad xl file jin me mene accounts ke hawale se programing,best formulation or vb ka istamal kiya ta usb ke virus ki waja se crupt
ho gai boht se xl repair sofware use kiye he lekin koai result samne nahi aaya plz aap log meri madad kare koai acha software ya koi or tariqa jis se me un file ko dobara istemal me la sakoo.

thanks

**robertfalco** · 23rd June 2009, 12:35 AM

Very nice work.Keep it up and thanks for sharing

**Mubashir Aziz** · 23rd June 2009, 09:45 AM

Thanks Robert & BL

**Mubashir Aziz** · 23rd June 2009, 09:47 AM

SHAHZAD58 said:

plz help me........meri boht hi karamad xl file jin me mene accounts ke hawale se programing,best formulation or vb ka istamal kiya ta usb ke virus ki waja se crupt
ho gai boht se xl repair sofware use kiye he lekin koai result samne nahi aaya plz aap log meri madad kare koai acha software ya koi or tariqa jis se me un file ko dobara istemal me la sakoo.

thanks

did you tried this method ??? see attached image .... after selecting the file from open tab you can click open & repair and see if it helps .......

agar iss say masla haal nah ho to iss thread ko check karain .....
http://itdunya.com/showthread.php?t=...ighlight=excel

**ALI RAZA QAMAR** · 23rd June 2009, 10:13 AM

very nice.....

Aap ne bahut hard work kya hai...

Bhai jaan isi tarah k aap r bhi excels formulae share kya karain

**Mubashir Aziz** · 23rd June 2009, 11:40 AM

Buhat Shukaria hosla afzai ka

brother main aap logon kay sath aur bhi formula’s share kar sakta hoon leekan agar Aap loog seekhna chahtay hain to khud koshish karain aur koi formula naheen banta ho to mujh say pocchain ….iss tarah mujhay pata lagay kah aap logoon kay pass kia queries hain aur main iss kay best solution kay liye koshish karoon ga …….

Allah Hafiz

**Mubashir Aziz** · 23rd June 2009, 11:47 AM

Main Best Solution wali sheet kay formula main mazeed improvement karta houn ……..

Question:
Hum Chahtay hain kah Best Solution wali sheet kay cell G3 main agar pass ho too hasilk karda number aur grade ikha aay:
Mark 450 Grade A

Aur Agar Fail ho to fail subject key ta'dad aur subject name likh aai :
Fail In 1 Subject Ch

Ans.
Tou Janab aap yah formula G3 main copy kardain aur daikhain result kia aat hay ... phir aap issay dosray cell G4 say G8 tuk drag kar kay copy kar saktay hain

Code:

=IF(COUNTIF(B3:F3,">=60")=5,"Marks "&SUM(B3:F3)&" Grade "&LOOKUP((SUM(B3:F3)/500*100),{0,60,70,80,90},{"Fail","D","C","B","A"}),"Fail In "&COUNTIF(B3:F3,"<60")&" Subject "&TRIM(REPT("E ",B3<60)&REPT("M ",C3<60)&REPT("Ph ",D3<60)&REPT("Ch ",E3<60)&REPT("Bi ",F3<60)))

Aap khud bhi koshish kar saktay hain apnay use kay liye iss main changes kar kay

**kamibest** · 16th July 2009, 08:17 PM

Mubashir Aziz said:

Main nay yah file kafi mahnat say tyyar key hay aur mairay khayla main aap main say buhat say loggon kay kaam aa sakti hay ..........

Iss File main Main nay Green Color walay column main formula's lagain hay aur aap loog iss say percentage aur grading waghaira kay baray main bhi seekh saktay hain .......

yar Excel Maire ko Bhi kuch Pouchna Hai Leken Mai Ap Ko Yaha Share nahi Karsakta Wo zara Important Data hai Customer ka