Excel Help Line مائیکرو سافٹ ایکسل ہیلپ لائن سینٹر

[Noorkhannoor]

Thnx

[uzair2020]

Assalam o Aliekum Bhai Syar
karwan kuch tham sa gaya hai plz is sisilay ko rawan dawan rakhay.
khud se hi koi thread bana kar paish karain. ap ki thread ka intizar rahay ga.
Fi Amanillah

[syar]

Assalam o Aliekum Bhai Syar
karwan kuch tham sa gaya hai plz is sisilay ko rawan dawan rakhay.
khud se hi koi thread bana kar paish karain. ap ki thread ka intizar rahay ga.
Fi Amanillah

Walikum
Bhai Lekh k tu bohat kuch rakha hoa ha. Lekan Urdu thread bana k present karna masla ha mere leye. Wese m volunteer deekh raha hon jo thread lekh d. Agar mil jae Tu inshallah jald he Pivot Table par aap bohat kuch lekha hua dekhain ge.

regards,

[sohail1966]

واقعی سیار بھائی اس سلسے کو آگے بڑھاتے رہیں۔۔
ہمارے پاس اگر پوچھنے کے لیے کچھ نھی تو آ پ خود ھی کچھ نہ کچھ شیئر کرتے رہا کرے۔۔۔۔

[uzair2020]

Assalam o Aliekum syar bhai
phir se ap ki help ki zaroorat paish aai hai. kya excel main asa function hai k ager main kisi value ko divide ko dosri value se devide karon or answer point main ho to wo result ko itna barha day k answer round figure main aa jaye.

40/3= 13.33333333

[sohail1966]

Assalam o Aliekum syar bhai
phir se ap ki help ki zaroorat paish aai hai. kya excel main asa function hai k ager main kisi value ko divide ko dosri value se devide karon or answer point main ho to wo result ko itna barha day k answer round figure main aa jaye.

40/3= 13.33333333

Faraz krain ke ap ka cell a2 mein hay.us par right click krein us ke bad:-
Format cell>Number
us mein decimal places ko zero kardaein aur use 1000 separator box ko uncheck kardein insh Allah ap ka masla hal hogye ga.

[uzair2020]

thanx sohail for the help. lakin bhai mujhe jis project k liye help chahiyay wo hai land revenue managment. or mujhe hissa calculator k liye asa function chahiyay suppose ager total 120 hisses hain. jin main 80 hisses 3 logon k or baqi 40 hisses 4 logon k hon. ab 40 to 4 logon per divide ho jayeingay coz dono even numbers hain per 80 ko 3 per dvide nai kar saktay. is surat main mujhe total hisses ko 3 guna barhana paray ga jis se pahlay 3 logon k hisse ho jayengay 80/360 or baqi 4 logon k hisses 30/360 ho jayengay.


80/360+80/360+80/360=240/360

30/360+30/360+30/360+30+360=120/360

=360/360 means 1/1

ap mera masla samajh gaye hongay. ager hisses enven numbers main to koi problem nahi mager odd numbers main hisses dvide karnay ki bajaye persons se multiply karna parta hai.
inshalla main jald apnay project calculator ka screen shot donga takay ap meri problem ko achi tarah samajh sakain.

[uzair2020]

syar bhai lagta hai ap lambi chutti per chalay gaye hain

[syar]

thanx sohail for the help. lakin bhai mujhe jis project k liye help chahiyay wo hai land revenue managment. or mujhe hissa calculator k liye asa function chahiyay suppose ager total 120 hisses hain. jin main 80 hisses 3 logon k or baqi 40 hisses 4 logon k hon. ab 40 to 4 logon per divide ho jayeingay coz dono even numbers hain per 80 ko 3 per dvide nai kar saktay. is surat main mujhe total hisses ko 3 guna barhana paray ga jis se pahlay 3 logon k hisse ho jayengay 80/360 or baqi 4 logon k hisses 30/360 ho jayengay.


80/360+80/360+80/360=240/360

30/360+30/360+30/360+30+360=120/360

=360/360 means 1/1

ap mera masla samajh gaye hongay. ager hisses enven numbers main to koi problem nahi mager odd numbers main hisses dvide karnay ki bajaye persons se multiply karna parta hai.
inshalla main jald apnay project calculator ka screen shot donga takay ap meri problem ko achi tarah samajh sakain.

kya aap apne sample sheet yahan p attached kar sakte. m sirf aap ka data ka layout dekhna chahta hon. k mujhy formula laganay m asani ho.
regards,

[uzair2020]

zaroor syar bhai main data file bhi attach kar donga or hissa calculator ka screen shot bhi. takay ap ko samajhnay main aasani ho. take care

[fazal_khaliq]

mera sawal ye he ke jab ham eik sheet se dosre sheet per data muntaqel kerte hain tu formula q badal jata he

[uzair2020]

Assalam o Aliekum syar Bhai
umeed hai ap khairyat se hongay ek masla darpaish aaya hai or wo yai k main ne ek list banai hai or mujhe us k lcm nikalna parta hai per ager list main blank cell hon to lcm function error de daita hai plz is ka koi hal bata dain. ap k jawab ka intizar rahay ga