advance excel tips k topic me aik expert ne kaha k agar ap ka boss products me 15% ka izafa kary to ap rate ko 1.15 se multiply karein. tel me ab8 that kasy pta chalta h k isy 1.15 se multiply krna h.
advance excel tips k topic me aik expert ne kaha k agar ap ka boss products me 15% ka izafa kary to ap rate ko 1.15 se multiply karein. tel me ab8 that kasy pta chalta h k isy 1.15 se multiply krna h.
15% = 15/100 = 0.15
Ab iss mein 1 add karain.
1+0.15 = 1.15
0.15 tak to smj lag gae h. but 1 add karny ke smj nae lage.
Waisay tu aam taur per yeh tareeqa hota hay.
Farz karain asal qeemat 100 thi, ab 15% izafa ho gaya tu asal qeemat ka 15% hova 15 (100*15/100). Tu iss izafay ko asal qeemat mein jama ker daitay hain, 100+15 = 115.
Aik aur tareeqa bhi hay.
Asal qeemat 100, izafa 15% (15/100 = 0.15) . Izafay mein 1 jama karain aur asal qeemat say zarb dain, ((1+0.15)*100) = 115.
Iss dosray tareeqay mein bhi ham wohi kaam zarb kay zaryay ker rahay hain.
Izafay mein 1 jama kernay say jab izafay ko asal qeemat say zarb dain gay, matlab 100*1.15, iss ko aisay bhi likh saktay hain (100*(1+0.15)) = (100*1)+(100*0.15) = 100+15 = 115. Kam pehlay tareeqay wala hi ho raha hay, per zarb kay zaryay.
Bookmarks