help excel formula

**MOuzzam shamim** · 22nd September 2013, 03:25 PM

Assalam alaikum . . mujy excel k formula main help chye pr jaldi bhai . . .

ek cel hah Cash Sale, Credit Card Charges %, Disscount %, Total Amount

D7 E7 F7 G7
1150 2.2 5 or yahn total

amount ajye

**Sahil_Jaan** · 22nd September 2013, 03:52 PM

بھائی ان دونوں کو سلیکٹ کر کے ایکسل پر ایک ای کا بلیک کلر کا نشان ہو گا جس کو آٹو سم کہتے ہیں وہ پریس کرو تو ان دونوں کا ٹوٹل سامنے آ جائے گا

**MOuzzam shamim** · 22nd September 2013, 04:08 PM

sum nhi chye . . . krna ye hai . . 1150 ka 2.2% or us main say 5% ho kr ajye. like this C7*D7/100

**Sahil_Jaan** · 22nd September 2013, 04:22 PM

بھائی اپ ساری اماونٹ لکھ دیں سکرین شوٹ میں پھر بتائیں کہ کیا کرنا ہے

**MOuzzam shamim** · 22nd September 2013, 04:43 PM

.

**azhar aali** · 22nd September 2013, 04:46 PM

Brother Cash Sale, Credit Card Charges %, Disscount %, Total Amount
cash sale + credit card charges - discount yahe ho ga formula end per total amount aa gye ge

**MOuzzam shamim** · 22nd September 2013, 06:07 PM

azhar aali said:

Brother Cash Sale, Credit Card Charges %, Disscount %, Total Amount
cash sale + credit card charges - discount yahe ho ga formula end per total amount aa gye ge

Bilkul hai . . likin mujy formula batao kia formula bany ga . . main ny ye formula banaya "=C7*d7/100" ye C/C ka formula bangya . . main jesy hi C/C k cell main 2.2 likhn ga total amount main value ajye gi. mgr ab main chata hn 2.2 C/C cell main likha or 5 discount waly cell main likhon . . to total amount ajye . . or 5% ka formula b yehi hah. "=C7*E7/100" . . likin ye dno formula ek hi cell main kesy lgy ga ye batao

**MOuzzam shamim** · 22nd September 2013, 06:11 PM

main total amount k cell main ye formula lga rha hn pr accept nhi ho rha . .
=c7*d7/100, c7*e7/100 . . pr ye galat hah . . shai formula knsi conditon apply hogi?