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

[syar]

Asslam-O-Alaikum
Janab mera Ek sawal Hai Ager Jawab Acha Mil jay Tu Kia Baat Ho
Mujhe Aik hi cel mein Ye formula Lagana hai Means ?
5% ko 1100 mein se nakalana hai Aur 700 ko 1100 mein se nikli hoi raqam mein plus kar dena aur ye formula aik hi cel mein lagana hai samjh na aye tu mein sheet post kar deta hoon Ok

salam::

agar m drust samjha hon tu Total wale cell m ya formula copy kar lain.

=(1100-(1100*5%))+700

agar aap ka commission % aur amount kisi cell m lekhe hoe ha tu oper deye gai formula m amount ko cell reference sa change kar lain. Ya apni sample sheet attached kr dain.

regard

[syar]

Salam.
friends main excel 2007 use ker raha hon. mainy is main jo excel ki file attach ki hai is main mainy apna masla bhi likh diya hai agar koi mera problem solve ker sakta hai tu kindly help.

Aap jesa chahte hain asa excel m mushkil sa ho ga. aik sorat ya ha k aaap is k leye koi macro programming lekhain ( Jo k difficult ha) dosra ya ha k aap merge cell khtam kr k jo sheet aap n bnae ha ise neeche copy kr lain. tu sare IDs k alag alag sheet ban jae gi aur phr print command d dain.

3rd aur asan method ya ha k aap is file ko ACCESS m export karian aur report ko aik dafa apni marzi ki formatting kr k print le lain aur access k table ko excel ki is file sa link krlain. jab bhe aap excel ki file m data enter karain ge. access m bhe table update hota rahe ga. print m bhe asani ho gi.

hope this will help u.

regards

[mchandg05]

aPP GrA888888888888 HO JEEEEEEEEEE
tHNX

[Ahmed220]

salam::

agar m drust samjha hon tu Total wale cell m ya formula copy kar lain.

=(1100-(1100*5%))+700

agar aap ka commission % aur amount kisi cell m lekhe hoe ha tu oper deye gai formula m amount ko cell reference sa change kar lain. Ya apni sample sheet attached kr dain.

regard

Syar bhai Masha Allah boht bhetreen kam kar rae ho ap Jab bi ap kay kam ko dekhta hu Dil Khush Hojata Allah Pak ap ko or Himat de (Ameen)

[sohail1966]

Aap jesa chahte hain asa excel m mushkil sa ho ga. aik sorat ya ha k aaap is k leye koi macro programming lekhain ( Jo k difficult ha) dosra ya ha k aap merge cell khtam kr k jo sheet aap n bnae ha ise neeche copy kr lain. tu sare IDs k alag alag sheet ban jae gi aur phr print command d dain.

3rd aur asan method ya ha k aap is file ko ACCESS m export karian aur report ko aik dafa apni marzi ki formatting kr k print le lain aur access k table ko excel ki is file sa link krlain. jab bhe aap excel ki file m data enter karain ge. access m bhe table update hota rahe ga. print m bhe asani ho gi.

hope this will help u.

regards

Very very Great Sir...

[syar]

Syar bhai Masha Allah boht bhetreen kam kar rae ho ap Jab bi ap kay kam ko dekhta hu Dil Khush Hojata Allah Pak ap ko or Himat de (Ameen)

Thanks

[syar]

Very very Great Sir...

Thanks

[syar]

Special Characters in Excel:

Aksar hum logo ko cell m Special Characters insert krne k zarorat parti ha, jese aap ko square meter k leye 2 super script m lkhna ho etc etc. Excel aap ko drj zel characters insert krne ki support deta ha, jo k aap
ALT+ Numeric Keypad k numbers k sath enter kr sakte hain

yahi aap ALT ko hold karain aur key combination k sath 178 enter karain gi tu square enter ho jae ga.

Note: Numeric key pad k keys use karain na k keyboard k oper wale numerics.

regards

[sohail1966]

Special Characters in Excel:

Aksar hum logo ko cell m Special Characters insert krne k zarorat parti ha, jese aap ko square meter k leye 2 super script m lkhna ho etc etc. Excel aap ko drj zel characters insert krne ki support deta ha, jo k aap
ALT+ Numeric Keypad k numbers k sath enter kr sakte hain

yahi aap ALT ko hold karain aur key combination k sath 178 enter karain gi tu square enter ho jae ga.

Note: Numeric key pad k keys use karain na k keyboard k oper wale numerics.

regards

Very Very nice sharing Sir,
Bohat Bohat shukria....

[usman_mohammad2]

Aslam o Alaikum
Main workbook bhe sath Attach kr raha hun

[syar]

Aslam o Alaikum
Main workbook bhe sath Attach kr raha hun

May be you already try this approach. Agar aap n try na kya ho tu give it a try. Used a helper table. May be you will enhance it further.

regards

[usman_mohammad2]

may be you already try this approach. Agar aap n try na kya ho tu give it a try. Used a helper table. May be you will enhance it further.

Regards

بہت مہربانی جناب میرا مسئلہ حل ہو گیا ہے