Excel Sum

[Qutab]

agar main kisi jaga per sum ka formula lagaon to vhan total amount sum ho jati hy. lekin us cell mein main koch aur cheez nai likh sakta, main chahta hon us cell mein jo word likho vo bhi as it is rhy aur amount ka sum bhi ho jay.
kya aisa koi formula hy.

[mfranakar]

میرے دوست آپ کا مسئلہ یہاں پر
http://www.itdunya.com/t300546-5/#post3152282
پوسٹ کر دیا ہے
اس کا رزلٹ بہت جلد بتا دیا جا ئے گا۔
محمد فیصل

agar main kisi jaga per sum ka formula lagaon to vhan total amount sum ho jati hy. lekin us cell mein main koch aur cheez nai likh sakta, main chahta hon us cell mein jo word likho vo bhi as it is rhy aur amount ka sum bhi ho jay.
kya aisa koi formula hy.

[syar]

2 method hain.

1. sum k formula k bad &"yourtext" lekh lain.
=sum(yourrange)&"yourtext"

2. Apne cell ki custom formatting kar lain.
Select Select---->Formatting--->Custom formatting---> aur ye code paste kar dain.
0"yourtext"
aur Ok kar dain. Jab bhe sum karain ga ap ka text lekha hoa aajae ga.

Custom formatting ap single cell aur Range dono ki kar sakte hain.

regards,

[Qutab]

Thanks msla hal ho gya. Lekin agr formating cell mein jay bagair kya koi aisa formula hy jis sy ye rupees show ho jay.
jo formula aap ne btaya hy us mein pehly amount ati hy baad mein Rs. lekin agr format mein ja kar is tarhan karo "Rs:"0 kro to vahan theek kya ja sakta hy. otherwise formula theek kam nai karta agr koi aur formula hy to plz bta do.

[syar]

Agar ap ye chahte hain k amount k sath Rs. Aae tu is k leye ap ko kisi custom formatiing k zaroorat nahee. Excel ne Pak currency k leye built in formatting rake ha ap wo use kar lai.
Select cell--->Format cell--->Number k Tab m Currency ko select karian---> aur symbol k drop down m PKR select kar lain jo Pakistani Rupees k leye ha.

regards,

[kasolangi]

Agar ap ye chahte hain k amount k sath Rs. Aae tu is k leye ap ko kisi custom formatiing k zaroorat nahee. Excel ne Pak currency k leye built in formatting rake ha ap wo use kar lai.
Select cell--->Format cell--->Number k Tab m Currency ko select karian---> aur symbol k drop down m PKR select kar lain jo Pakistani Rupees k leye ha.

regards,

Nice..

[M Imran Mugal]

2 method hain.

1. sum k formula k bad &"yourtext" lekh lain.
=sum(yourrange)&"yourtext"

2. Apne cell ki custom formatting kar lain.
Select Select---->Formatting--->Custom formatting---> aur ye code paste kar dain.
0"yourtext"
aur Ok kar dain. Jab bhe sum karain ga ap ka text lekha hoa aajae ga.

Custom formatting ap single cell aur Range dono ki kar sakte hain.

regards,

"SYAR bhai boht khobe umda very nice yaaaaaaarrrrrrr

[Dil_Shah]

Problem Hal ho gaii?