Helitaanka boqolleyda isbeddelka ee Excel waxay u baahan tahay xisaabinta faraqa u dhexeeya laba lambar, iyada oo loo qaybinayo faraqa tirada isku xigta oo loo beddelo qiimaha jajab tobanle ilaa boqolkiiba. Haddii ay dhacdo tirooyin kala duwan, waxaad hoos u soo jiidi kartaa qaacidada guud ahaan tirada tirooyinka.

Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel

Aynu fahanno aasaaska isbeddelka boqolleyda. Isbeddelka boqolkiiba waa (qiimihii hore ee cusub)/qiimihii hore. Haddaba, hab-raaca boqolleyda beddelka qaaciidada waxay noqotaa:

=(<cell with new value>-<cell with old value>)/<cell with old value>

Halkee,

• <unug leh qiime cusub> waa unugga labaad ee xisaabinta
• < unug leh qiimihii hore> waa unugga ugu horreeya ee xisaabinta

Habkani wuxuu noqon karaa mid lagu dabaqi karo laba unug oo random ah oo ku yaal xaashida Excel , marka laga reebo marka aad u baahan tahay inaad ka hesho natiijooyinka unugyo kala duwan adoo isticmaalaya ikhtiyaarka Buuxi . ^(Fill)Markaas, unugyada dooddu waxay u baahan yihiin in la dhigo isku saf oo ka kooban laba tiir oo kala duwan.

Tusaale ahaan. Waxaan ku haynaa qiyam kala duwan oo tiirar B iyo C ah oo ka bilaabmaya safka 3. Markaa qiyamka isbarbardhigga ugu horreeya wuxuu noqonayaa unugyada B3 iyo C3.

Qaaciddada lagu xisaabinayo faraqa boqolkiiba ee unugga B3 ilaa unugga C3 waxay noqonaysaa:

=(C3-B3)/B3

Halkee, B3 waa unugga ugu horreeya ee kala duwanaanshaha unugyada guud ahaan tiirka B kaas oo aan ka bilowno xisaabinta isbeddelka boqolkiiba.

C3 waa unugga ugu horreeya ee kala duwanaanshaha unugyada guud ahaan tiirka C ilaa aan xisaabinno isbeddelka boqolkiiba.

Aynu nidhaahno waxaan u baahanahay tirada unugyada leh farqiga boqolleyda ee tiirka E. Kadibna dhig qaacidada lagu ogaanayo farqiga boqolleyda ee tusaalahan unugga E3.

Si kastaba ha ahaatee, tani waxay ku siinaysaa qiimaha iskudarka ama qaab jajab tobanle. Si aad u hesho qiimaha qaabka boqolleyda, fadlan dhagsii badhanka boqolleyda^(Percentage) ee qaybta lambarka^(Number) ee ribbon .

Mar labaad, natiijadu waa hal unug oo keliya. Si aad natiijada hoos ugu soo jiiddo tiirka oo dhan, adeegso hawsha Buuxi^(Fill) . Aynu ka soo qaadno natiijooyinka waa in la tiriyaa ilaa safka 16 iyo isku mar ilaa unugga E16 , ka dibna waa inaad mar labaad gujisaa unugga C3.

Marka la doorto, dhagsii dhibicda yar ee ku taal geeska midig ee hoose ee unugga si aad u muujiso ikhtiyaarka Buuxi . ^(Fill)Hadda adigoon sii deynin mouse-guji, u jiid xulashada hoos E16 .

Rajo inay ku caawiso!

How do you calculate Percentage increase or decrease in Excel?

Finding percentage change in Excel requirеs cаlculating the difference between two numbеrѕ, dividing that differenсe by the successive nυmber and chаnging the decimal value to a percentage. In сase of a range of numbers, you could pull the formula down aсross the rаnge of numbers.

How do you calculate percentage increase or decrease in Excel

Let us understand the basics of the percentage change. The percentage change is (new value-old value)/old value. Thus, the syntax for the percentage change formula becomes:

=(<cell with new value>-<cell with old value>)/<cell with old value>

Where,

• <cell with new value> is the second cell in the calculation
• <cell with old value> is the first cell in the calculation

This formula could be applicable for any two random cells across the Excel sheet, except when you need to find the results across a range of cells using the Fill option. In that case, the cells in discussion need to be placed in the same row across two different columns.

Eg. We have a range of values in columns B and C starting from row 3. Thus the first comparison values would be in cells B3 and C3.

The formula to calculate the percentage difference from cell B3 to cell C3 would become:

=(C3-B3)/B3

Where, B3 is the first cell in the range of cells across column B from which we start calculating the percentage change.

C3 is the first cell in the range of cells across column C till which we calculate the percentage change.

Let us say we need the range of cells with the percentage difference in column E. Then place the formula for finding the percentage difference in this example in cell E3.

However, this would give the value in integer or decimal format. To attain the value in percentage format, please click on the Percentage button in the Number section of the Ribbon.

Again, the results are for one cell only. To pull the results down across the column, use the Fill function. Let us suppose the results are to be counted till row 16 and simultaneously till cell E16, then you would have to click on cell C3 once again.

Once it is selected, click on the small dot at the right-bottom corner of the cell to highlight the Fill option. Now without releasing the mouse-click, pull the selection down to E16.

Hope it helps!

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 OR shaqada Excel si loo go'aamiyo haddii xaaladdu run tahay

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

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

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

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Casharka Microsoft Excel, ee Bilowga ah

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel