Excel fomulas

[alim khan]

EXPERTS MERI MADAD KAREN MAY NE EK MASTER SHEET BANAI HAI US MEIN
A B C MEIN ALAG ALAG BRAND KI KEMAT HAI MUJHE UN MEIN DIFRENCE NIKALNA HAI JO KE FIRST SHEET MEIN AAEGA AGAR FIRST SHEET MEIN MAI QUANTITY LIKHTA HUN TO WOH A B C D AMOUNT AUR DISCNT KE HISAB SE RATE KA DIFFRENCE MUJHE FIRST SHEET MEIN AANA CHAHIYE WAISE TO MAINE MASTER SHEET BANA LI HAI LEKIN US MEIN EK MUSHKIL AA RAHI HAI JAB MAI AMOUNT AUR QUNTY(I) KO (*) KARTA HUN TO (J) MEIN ALAG FIGAR AA RAHA HAI.MUJHE JO FIGUR CHAHIYE(L*M=N) WOH MAINE SIDE MEIN DIYA HAI. WAISA HI FIGUR MUJHE (F*I=J) MEIN CHAHIYE.PLS KOI IS KA FORMULA BATAE.

[zulfi721]

bhai aap ny jis column main amount likh rakhee hy na or jo formula aap ny us jaga py lagaya hy us main mis take hy.......check it.......han agar aap ko ye solved chaheyah to detail main btao k column a b c d kiya hain discount kiya hy rate ke percentage kitnee hy........aap conceptually mistake kr rahy ho...

[alim khan]

bhai aap ny jis column main amount likh rakhee hy na or jo formula aap ny us jaga py lagaya hy us main mis take hy.......check it.......han agar aap ko ye solved chaheyah to detail main btao k column a b c d kiya hain discount kiya hy rate ke percentage kitnee hy........aap conceptually mistake kr rahy ho...

M.R.P -99 DISCN.- 65 amunt- 35 EXTRA- 2 MUJHE WOH CHEEZ 35 MEIN AA RAHI HAI. AGAR MAI QNTY-10 LETA HUN TO WOH MUJHE350 MEIN AANI CHAHIYE LEKIN SHEET MEIN NET AMOUNT 347 AA RAHA HAI
mujhe aisa chahiye. amnt 35 * 10 QNTY = 350 NET



99-65%=35+EXTRA 5%=2 MERI KIMAT =35

[zulfi721]

brother ye extra kis cheez k charge kr rahy ho...

item price =99 hy 65% discount k bad vo aap ko 35 rupee main miltee hy,kya aap ye kehna chahty ho to phir extra 5% kiss chez ka charge kr rahy ho.....dsp kiya hy?jb tk aap scenario clear nahin krty ye complex hoti jy geeeeeeeeee.

[sayhellotoit]

Asal mein Sheet A kay column F (amount) mein jo value hay woh 34.65 hay, per aap nay Cell format ko Number set kia hova hay iss liyay 35 dikh raha hay, tabhi aap ka NET 34.65*10=346.5=347 nazar aa raha hay. Jab keh aap chah rahay hain keh NET column mein : 35*10=350 nazar ayay.

Aap column F (amount) mein yeh formula likhain:
=ROUND(D4-(D4*E4)/100,0)

sahi ho jayay ga