Shaqaaluhu^(Functions) waxay sameeyaan xisaabinta xisaabeed ee unugyo kala duwan oo ku jira Excel . Hawlaha^{(Functions )(Functions )} ugu caansan waa SUM , celcelis^(AVERAGE) ahaan , COUNT , MIN , iyo MAX . Haddii shakhsigu rabo inuu helo celceliska, ugu yaraan, ama ugu badnaan xogtiisa, waxay isticmaali karaan celceliska , MIN , iyo^(AVERAGE) MAX Functions^{(MAX Functions)} . Maqaalkan, waxaan ku tusineynaa sida loo xisaabiyo celceliska^(Average) , ugu yar^(Minimum) , iyo ugu badnaan^(Maximum) ee Excel .

Celceliska, MIN , iyo MAX^{(MAX Functions)} Hawlaha Excel

• Celceliska^(AVERAGE) : Wuxuu helaa qiimaha tirooyinka unug gaar ah wuxuuna soo celiyaa celceliska qiimaha hal ama ka badan. Waxay noqon kartaa magacyo, habab, iyo tixraacyo ka kooban tirooyin.
• MIN : Waxay ka heshaa qiimaha ugu yar ee unugyo kala duwan.
• Max : Wuxuu ka helaa qiimaha ugu badan ee unugyo kala duwan.
  

Waxaan dooneynaa inaan sharaxno sida:

1. Si loo Helo Celceliska Qiimaha
2. Si loo Helo Qiimaha Ugu Yar
3. Si loo Helo Qiimaha Ugu Badan

1] Si loo Helo Celceliska Qiimaha

Waxaad ka heli kartaa Celceliska^(Average) qiimaha adiga oo dooranaya unugga hoose ama dhanka midig ee qiyamka aad rabto inaad celcelis ahaan^(Average) . Kadib tag Kooxda Tafatirka^{(Editing Group)} , dooro Qalabka ^(Tool)Isku-dhafka^(Auto-Sum) . Waxaad arki doontaa liiska hoos u dhaca ee hawlaha, dooro Celceliska^(Average) . Hadda celceliska^(Average) qiimaha waa la helay.

Xulashada kale waa in aad doorato unugga aad rabto in aad celcelis ahaan^(Average) noqoto , ka dib waxaad tagtaa Auto-Sum ee Kooxda Tafatirka^{(Editing Group)} oo dooro Functions dheeraad ah . Sanduuqa wada hadalka shaqada^{(Insert Function)} Gelida ayaa soo bixi doona, dooro Celcelis ahaan^(Average) , Kadibna OK. Geli^(Enter) kala duwanaanta unugyada sanduuqa doodda Functions^{(Functions Argument)(Functions Argument)} , ka dibna OK .

Waxa kale oo aad ku qori kartaa celceliska caanaha unugga ( =AVERAGE (C6:C13 )) si aad u hesho qiimaha.

2] Si loo Helo Qiimaha Ugu Yar

Dooro unugga hoose ama midig, ka dibna u tag Qalabka Auto-Sum^{(Auto-Sum Tool)} ee Kooxda Tafatirka^{(Editing Group)} oo dooro Min Function ama dooro Function dheeraad ah^{(More Function)} ; Sanduuqa wada hadalka Gelida Function^{(Insert Function)} ayaa soo muuqan doona oo dooran doona Celceliska^(Average) , Kadibna OK . Geli kala duwanaanshaha unugyada sanduuqa doodda Functions^{(Functions Argument)} , ka dibna OK.

Waxaad sidoo kale ku qori kartaa caanaha (= MIN (C6:C14 ) gudaha unugga si aad natiijada u hesho.

3] Si loo Helo Qiimaha Ugu Badan

Dooro unugga hoose ama midig, ka dibna u tag Qalabka Isku-gubka^{(Auto-Sum Tool)} ah ee Kooxda Tafatirka^{(Editing Group)} oo dooro Max Function ; waxay si toos ah ku siin doontaa natiijada. Ama waxaad riixi kartaa shaqo dheeraad ah sanduuqa Wadahadalka Gelida ayaa soo bixi doona, ^{(Insert Dialog)}Geli^(Enter) tirada unugyada ee sanduuqa doodda Functions^{(Functions Argument)} , ka dibna OK.

Waxaad sidoo kale ku qori kartaa caanaha ( =MAX (C6:C15 ) unugga oo aad hesho natiijada.

Waa kaas.

How to use MIN, Max, and AVERAGE Functions in Excel

Functions perform a mathematical calculation on a range of cells in Excel.  The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX.  If an individual wants to find the average, minimum, or maximum of their data, they can use the AVERAGE, MIN, and MAX Functions. In this post, we show you how to calculate Average, Minimum, and Maximum in Excel.

AVERAGE, MIN, and MAX Functions in Excel

• AVERAGE: Finds the value of numbers in a particular cell and returns the mean value of one or more values. It can be names, arrays, and references that contain numbers.
• MIN: Finds the minimum value in a range of cells.
• Max: Finds the maximum value in a range of cells.
  

We are going to explain how to:

1. To Find the Average Value
2. To Find the Minimum Value
3. To Find the Maximum Value

1] To Find the Average Value

You can find the Average of a value by selecting the cell below or to the right of values that you want to Average. Then go to the Editing Group, select the Auto-Sum Tool. You will see a drop-down list of the functions, select Average. Now the Average value is found.

The other option is to select the cell you want to Average, then go to Auto-Sum in the Editing Group and select more Functions.  An Insert Function dialog box will pop up, choose Average, Then OK. Enter the range of cells in the Functions Argument box, then OK.

You can also type the Average formula in the cell (=AVERAGE (C6:C13) to get the value.

2] To Find the Minimum Value

Select the cell below or right, then go to the Auto-Sum Tool in the Editing Group and select the Min Function or select More Function; an Insert Function dialog box will pop up and choose Average, Then OK. Enter the range of cells in the Functions Argument box, then OK.

You can also type the formula (=MIN (C6:C14) in the cell to get the result.

3] To Find the Maximum Value

Choose the cell below or right, then go to the Auto-Sum Tool in the Editing Group and select the Max Function; it will automatically give you the result. Or you can click more function an Insert Dialog box will appear, Enter the range of cells in the Functions Argument box, then OK.

You can also type the formula (=MAX (C6:C15) into the cell and get the result.

That’s it.

Related posts

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Excel

• Xisaabi Iskucelceliska Dhaqdhaqaaqa Fudud, Miisaan, iyo Sarbeeb

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo xisaabiyo celceliska dhibcaha dhibcaha ama GPA gudaha Excel

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

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

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

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga