MS Excel Main Result Tayar Karain – Step By Step

[Mubashir Aziz]

@sajid have you seen my last thread http://itdunya.com/showthread.php?t=82565

Darasal yah sheet main newly users ko sikhanay kay liye bana raha hoon aur step by step chal raha hoon warna main yah tamam kaam without IF kay bhi kar sakta tha leekan step by step chalnay say yah faida hoga kah samjh main aa jay gi .... aap beginners level say oper kay uers hogay to aap kay zahan main yah sawal aaya , buhat achi baat leekan bhai dosroay loog jo beginer level kay unn ka bhi khayl karain .... InshaAllah main aap ko end main tamam column kay bajay ek he column main tamam formula's ko combine kar kay reslut day doon ga ...bus thora sa sabar krain ..... aur let me check kah kuch aur loog bhi interest lain to baat banay .......

[راقم]

بھائی مبشر عزیز،
السلام علیکم۔
آپ تو کمال کے آدمی نکلے۔بہت ہی اچھا اور مفید تھریڈ ہے۔
اگر آپ کی اجازت ہو تو میں اس تھریڈ میں سمجھائی گئی باتیں ایم ایس ورڈ میں اردو میں لکھوں۔ اس میں کچھ دیر تو لگے گی لیکن ان شاء اللہ میں لکھوں گا۔
میری طرف سے آپ کو بہت بہت مبارک ہو۔ مجھے بھی ایکسل سے دلچسپی ہے اس لیے میں اس طرح کے تھریڈ بڑے شوق سے پڑھتا ہوں۔ میں نے یہ پورا تھریڈ کاپی کر لیا ہے، صرف آپ کی اجازت درکار ہے۔
انتظار کروں گا۔

والسلام

خیر اندیش
عبدالعزیز راقم

[robertfalco]

zabaardast muje acha laga yeah tutorial

[Mubashir Aziz]

Pasandeedagi ka shukaria robert ....

[Mubashir Aziz]

Bhai Raqim
WSLM::

aur buhat khushi hoi kah kissi ko maira yah thread itna acha laga aur sub say barh kar yah khush hoi kah aap iss ka urdu main tarajma karna chahtay hain ……. Yaar mairay liye iss say bari khushi key kia baat hogi maira thread ziyada say ziyada logoon kay kaam aa sakay …….. Actually yah basic concept hain aur agar aap ko yah clear ho gai ho to main aap logoon ko thora sa advance level ko kaam bhi sikhaon ga leekan agar aap jaisay kuch aur bhi excel lover mill jain to dilchaspi barqarar rahay gi ……
Baharhaal aap kay pass excel related koi bhi query ho to mujh say poochain InshaAllah main pori pori koshish karoon ko ussay solve karnay key ……

Main nay kuch aur thread bhi post kiye hain aap chahain to unn ka bhi urdu tarjama kar saktay hain inn main say Validation aur meeting room schedule chotay thread hain aur agar aap chahain to in ka aasani say tarjma kar saktayhain ….

Mairay thread yah hain ….

MS Excel Main Result Tayar Karain – Step By Step
http://itdunya.com/showthread.php?t=87020

Excel : Validation Main Dosri Sheet Say Data Use Karna
http://itdunya.com/showthread.php?t=65418

MS EXCEL - Prepare Meeting Room Schedule
http://itdunya.com/showthread.php?t=91695

For Advanced Users
MS EXCEL main Result Tayar Karna .....
http://itdunya.com/showthread.php?t=82565

[Mubashir Aziz]

Use of & Operator & Trim() Function

TRIM() Function
Yah kiss bhi cell main 2 ya 2 say ziada words kay darmiya tamam khali spaces ko remove kar daita siwai 1 space kay …… Naheen samjh main aaya ?? chalin example kartay hain ……
Aap A1 cell main Apple Jam likh dain aur Appli aur jam kay darmiya kafi spaces daal dain ….. iss tarah
A1=Apple Jam
Aap ko A1 cell main youn likha aai ga …." Apple Jam "
Aap B1=Trim(A1) likhina aur enter karain. Kia aaya ????
G Janab B1 cell main "Apple Jam" likha aaya leekan spaces ghaib ho gai hain … bus yah kaam Trim karata hay

& Operator
Yah two strings matlab to words ko ya do numberic ko aapus main jornay ka kaam aata hay …..
Example
A1=Hello
B1=Ali
C1=Come On
Aab aap D1 main tamam words ko kaisay lain gay ???????
D1=A1&B1&C1 Enter karain
Kia aaya ??
D1=HelloAliComeOn
Yah to tamam akhta aa gia, iss kay darmiya gape hona chahiye na tou kaisay aay ga ???? ghabrain mat likhye ….
D1=A1&” “&B1&” “&C1 Aab enter karain
D1=Hello Ali Come On
Tou Janab hum nay & operator ko use kartay ho aik space ko darmiya main add kar dia yaad rahay kay koi bhi text ko jornay kay “ “ Start aur End main Zaroor dalain ga but Cell address ko baghari “ “ kay likhain gay …..
Issay Aur clear Kartay hain
D1=A1&”,“&B1&”!”&C1
Kia aaya
D1=Hello,Ali!Come on
Aap , aur Ali kay darmiya space chahtay hain ?? Kia karain ?? Mujhay pata hay aap nay to try karni naheen hay main he bata daita houn ……
D1= A1&","&B1&" ! "&C1
Kia bana
D1=Hello, Ali ! Come on
Aik cheez ka khayal rakhain “ “ inverted comma’s key board say enter kar lijiye gab coz sometime “ “ forum say excel main copy kartay ho kaam naheen karay hain …. Iss liye paraishan mat hoiye ga ……

Aab aap youn likhan yaan “ “ kay darmiya kafi ziya space day dain ….
D1= A1&", "&B1&", "&C1
Enter karnay par kia jawab aay a
D1=Hello, Ali, Come one
Aab aap Trim ko zahan main Lain
D1= TRIM(A1&", "&B1&", "&C1)
Kia jawab aana chahiye ?????? G Jaanb extra spaces will be removed …
D1=Hello, Ali, Come On ….
Janab aap iss key practice karain keonkah ooper diya gia Lesson-5 , "IF" aur yah donoon functions ("&" and "TRIM() ) ko ista’mal kartay hoye haal ho ga ……..

Allah Hafiz,

[qamar_zaman]

what about position calculations in a class

[sajjulkhan]

aoa.vv Nice And Informative Lessons. Main Nay App Ki Post Parhi Aur Bohat Kuch Seekhnay Ko Milla .xls Kay Mazeed Posts Send Karain Plz Aur Agar App Ka Koi Mailing Address Hay To Xls Ky Prob App Say Discuss Karna Chahti Hoon.

[Mubashir Aziz]

@Qamar you can ask any question not related to this thread Question in Ask An Expert with Excel in Title ..........
Iss Thread main main sirf Dosstoon ko relevant issues bata raha houn aur agar main jump kar kay next topic par gia to tamam issues clear naheen houn gay ............... Hope you got my point .......

[Mubashir Aziz]

@ Thanks Sajjul ,
Agar aap nay sahih tareeqay say maira thread solve kar lia tou aap ko 50% Excel concept clear ho jai ga aur aap chotay motay formula khud create kar lia karain gay ... Aap step by step khud practice karain tou InshaAllah aap ko faraq pata lag jai ga ....
We can't share email address as its against the forum rules ...
Aap Ask In Expert main Question pooch saktay hain leekan Title main aap iss tarah likhain gay to Excel key know how rakhnay walay aap ko guide kar saktay hain ................... Excel : <aap ka msla>

[Mubashir Aziz]

Lesson- 5-b – Calculation 5 ….. (Calc 5 = Column K = If Fail then Subject Name )




Iss Formula ka pahla part to tamam ka tamam Lesson 3 wala hay yaani

IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS", <IF FALSE >

Hum nay aaj <IF False > par kaam karana hay keonkah main “Pass” wala part Lesson-5 main bata chukka houn ………..


Lesson 5

Aab False Condition main aap nay apnay dimagh ko hazir rakhan hay aur sochna hay kah kia karain ……. Lesson 4 ko zahan main lay kar aain hum nay nested IF’s use key theen …….Chalin farz kia B2 main 60 say kum number aa gai to kia hoga hum issay kahtay hain kah column main Eng Likh day ….

Simple IF(B2<60,”Eng”.” “)

Logical Test : B2<60
If True : “Eng”
If False: ““ blank kar day

B2 main value 55 likh dain
To ab K2 main yah formula likh dain
K2=IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS",IF (B2<60,"Eng",""))
Ans: Eng

Keonkah logical test false howa to pass naheen likha aur False key taraf gaiy udhra B2 < 60 yaani 60 say chota hay to Eng likh di agar nah hota to blank kar daita ….. Chalain g iss key samjh aagai hay …. Leekan aab dosra masla agar Eng main Pass aur Math main Fail ho to kia karain ???????? zara Sochain ?????

K2=IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS",IF (B2<60,"Eng",""))

Farz kia kah C2 “Math” main bhi student fail ho jata hay to uss subject ka naam bhi lkha howa aana chahiye ….. Tou Janab aap aab Zahan ko hazir karain aur & and Trim() ko use karain ….

=IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS",TRIM (" "&IF(B2<60,"Eng","")&" "&IF(C2<60,"M","")))

Hum nay & ko use kartay hoye next If Condition bhi laga di ka agar IF(C2<60,"M","") agar C2 less then C ho to M likha howa aay warna space ……jaanb aab result step by step youn banay ga aap B2 aur C2 main doon main student ko fail karain ….tou hisaab kitaab youn banay ga …….
TRIM(<space>Eng<space>Math<space>)
Ans. Eng Math
Aab aap C2 main marks 65 likh dain to janab procedure you chalay ga
TRIM(<(<space>Eng<space>””)
Aab trim extra spaces ko clean kar day ga yaani akhri 2 spaces ko jawab aai ga
Eng

Aab Janab aab pura formula enter kar dain
K2=IF(AND(B2>59,C2>59,D2>59,E2>59,F2>59),"PASS",TR IM(" "&IF(B2<60,"Eng","")&" "&IF(C2<60,"M","")&" "&IF(D2<60,"Ph","")&" "&IF(E2<60,"Ch","")&" "&IF(F2<60,"BI","")))

Aur bari bari different subjects main logoon ko fail kartay rahain aur daikhain fail subject K2 main bhi change ho rahay hain kah naheen !!!!!


Tou Janab maria kaam khatam howa aab aap main say kissi ko clarifications chahyie to mujh say pooch sakta hay …..

[kamibest]

Very Nice Mubasshir