Farqiga boqolleyda waxaa badanaa la xisaabiyaa marka aad rabto inaad ogaato farqiga u dhexeeya boqolkiiba laba tiro. Microsoft Office Excel waa qalab fiican oo kaa caawinaya inaad bilowdo. Maqaalkan, waxaan ku aragnaa habka lagu helo farqiga^{(find the percentage difference)} u dhexeeya 2 lambar ee Excel.

Xisaabi^(Calculate) farqiga u dhexeeya labada lambar ee Excel

Isbeddelka boqolkiiba ama farqiga boqolkiiba waxa lagu dabaqi karaa cadad kasta oo aad qiyaasto muddo ka dib. Waa fikrad xisaabeed fudud oo ka dhigan heerka isbeddelka wakhtiga. Isticmaalka qaacidooyinka fudud ayaa kaa caawin kara inaad hesho farqiga boqolkiiba ee u dhexeeya 2 lambar. Waa kan sida!

1] Geli qiyamka^{(1] Enter values)}

Isbeddelka qiimaha boqolleyda waxaa lagu qeexi karaa faraqa u dhexeeya qiimaha asalka ah iyo kan cusub, oo loo qaybiyo qiimaha asalka ah.

Tusaale ahaan, Shirkad waxay iibisay $485,000 sanadka 2018 iyo $598,634 sanadka 2019. Haddaba, waa maxay boqolkiiba isbeddelka labada sano?

Furo Xafiiska Excel^{(Office Excel)} . Samee laba^{(Make two)} miis ' Iibka 2018^{(2018 Sales)} 'iyo' Iibka 2019^{(2019 Sales)} ' ( Calaamadee^(Highlight) xarfaha 'Bold', si aadan ugu khaldamin xisaabinta boqolkiiba).

2] Isticmaal caanaha^{(2] Use the formula)}

Marka xigta, dhagsii unugga B3 si aad u dabaqdo qaabka boqolleyda^(Percentage) unugga.

Hadda, u gudub tabka ' Home ' oo hoosta 'Format Number' dooro badhanka boqolleyda^(Percentage) , sida ka muuqata sawirka kore.

Fiiro gaar ah: Haddii aad isticmaalayso nooca shabakadda ee Excel , ie, Excel ee shabakadda, dhagsii Hoyga^(Home) > Qaabka Lambarka^{(Number Format)} > Boqolkiiba^(Percentage) .

Intaa ka dib, guji gudaha unugga B3 , u qaybi iibka sanadka labaad ($598,634.00) sanadka ugu horeeya ($485,000.00), ka dibna ka jar 1. Isticmaal caanaha soo socda ee unugga C3 . == (B2/A2)-1.

Marka la sameeyo, isbeddelka boqolkiiba inta u dhaxaysa labada sano waa la xisaabin doonaa oo la soo bandhigi doonaa isla markiiba. Sida aad arki karto, isbeddelka boqolkiiba inta u dhexeeya labada sano waxaa la ogaaday inuu yahay 23%.

U fiirso^(Notice) jaantusyada ku wareegsan ( B2/A2 ). Excel waxa uu marka hore xisaabiyaa waxa ku jira jaantusyada, ka dibna ka gooyaa 1.

Waxaan rajeynayaa inaad u aragto tilmaantan mid waxtar leh.
^{(I hope you find this tip useful.)}

How to calculate percentage difference between two numbers in Excel

The percentage difference is usually calculated when you want to know the difference in percentage between two numbers. Microsoft Office Excel is а great tool to help yoυ get started. In thiѕ post, we see the method to find the percentage difference between 2 numbers in Excel.

Calculate percentage difference between two numbers in Excel

Percentage change or percentage difference can be applied to any quantity that you measure over time. It is a simple mathematical concept that represents the degree of change over time. The use of simple formulas can help you find the percentage difference between 2 numbers. Here’s how!

1] Enter values

The change in percentage value can be defined as the difference between an original and a new value, divided by the original value.

For example, A company sold $485,000 in 2018 and $598,634 in 2019. Then, what’s the percent change in the two years?

Launch Office Excel. Make two tables ‘2018 Sales’ and ‘2019 Sales’ (Highlight the letters in ‘Bold’, so you don’t mistake them for percentage calculation).

2] Use the formula

Next, click on the cell B3 to apply the Percentage format to the cell.

Now, go to the ‘Home’ tab and under ‘Number Format’ select the Percentage button, as shown in the image above.

Note: If you are using the web version of the Excel, i.e., Excel for the web, click Home > Number Format > Percentage.

After that, click inside cell B3, divide the second year’s sales ($598,634.00) by the first year ($485,000.00), and then subtract 1. Use the following formula in cell C3. =(B2/A2)-1.

Once done, the change in percentage between the two years will be calculated and displayed instantly. As you can see, the change in percentage between two years was found to be 23%.

Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

I hope you find this tip useful.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah