Joometri^(Geometry) waxaa loo yaqaanaa inuu ka dhigo xisaabta iyo xisaabinta mid fudud. Baaxadda qaababka aasaasiga ah sida leydi, saddex xagal, iyo goobada waxaa lagu xisaabin karaa iyadoo la isticmaalayo qaacidooyin gaar ah. Haddii aad u baahan tahay inaad xisaabiso bedka qaababka aasaasiga ah ee gelitaanka kala duwan, Excel aad bay faa'iido u yeelan doontaa. Maqaalkan, waxaan ku sharaxnay habka loo xisaabiyo meelaha leydi, goobada, iyo saddexagalka Excel .

Xisaabi bedka leydi^(Rectangle) ee Excel

Habka aasaasiga ah ee xisaabinta bedka leydi ee Excel waa: dhererka * dhererka. Haddaba, hab-raacyada qaacidada lagu heli karo bedka leydi ee Excel waxay noqonaysaa:

=<cell with length>*<cell with height>

Tusaale ahaan. Aynu ka soo qaadno inaan haysano liis dhererka leydiyada oo ku faafay tiirka A laga bilaabo unugga A3 ilaa A11 iyo dhererka leydiyada oo ku faafay tiirka B ee B3 ilaa B11 . Waxaan u baahanahay bedka leydi ee tiirka C laga bilaabo C3 ilaa C11 .

Hadda, qaacidada leydi ee C3 waxay noqon doontaa:

=A3*B3

Waxaad isticmaali kartaa shaqada Buuxinta^(Fill) si aad caanaha ugu soo dejiso C11 . Kaliya^(Simply) dhagsii meel ka baxsan unugga C3 oo dib ugu soo celi. Ka dib isticmaal badhanka buuxinta ee geeska hoose ee midig si aad hoos ugu soo jiidato xulashada C11 .

Xisaabi aagga saddexagalka^(Triangle) ee Excel

Habka xisaabinta bedka saddexagalka waa (dhererka * dhererka)/2. Haddaba, hab-raacyada qaacidada lagu helo bedka saddexagalka ee Excel waxay noqonaysaa:

=(<cell with length>*<cell with height>)/2

Tusaale ahaan. Aynu tixgelinno dhererka iyo dhererka tiirarka A iyo B sida tusaalihii hore. Waxaan u baahanahay meelaha saddexagalka ee tiirka D laga bilaabo D3 ilaa D11 .

Hadda, qaacidada saddexagalka C3 waxay noqon doontaa:

=(A3*B3)/2

Waxaad isticmaali kartaa shaqada Buuxinta^(Fill) sida hore loogu sharraxay si aad caanaha ugu soo dejiso D11 .

Xisaabi aagga Goobo^(Circle) ee Excel

Bedka goobaabintu waa 3.14*(radius*radius). Si loo abuuro qaaciddada Excel , waxaan soo jeedin karaa shaqada jibbaarada si kastaba ha ahaatee, maadaama ujeedadu tahay kaliya in la helo labajibbaaran, waxaan ku maroojin karnaa caanaha wax yar. Halbeegga lagu helo agagaarka goobada ee Excel waa sida soo socota:

=3.14*<cell with radius>*<cell with radius>

Tusaale ahaan, haddii aan haysano liiska radiyada ee tiirka F ee F3 ilaa F11 oo aan u baahanahay meelaha wareegyada ku jira tiirka G ee G3 ilaa G11 , markaa qaacidada unugga G3 waxay noqon doontaa:

=3.14*F3*F3

Waxaad isticmaali kartaa shaqada Buuxinta^(Fill) si aad caanaha ugu soo dejiso unugga G11 .

Tani miyay shaqeysaa?

How to calculate area of Rectangle, Triangle or Circle in Excel

Geometry is known to make mathematics and calculations easy. The areа of basic shapes like rectangle, triangle, and cіrclе can be calculated using certain formulae. If you need tо сalculate the area of basic shapes for a range of entries, Excel would be very useful. In this article, we have explained the procedure to calculate areas of a rectangle, circle, and triangle in Excel.

Calculate the area of a Rectangle in Excel

The basic formula for calculating the area of a rectangle in Excel is: length * height. Thus, the syntax of the formula for finding the area of a rectangle in Excel would become:

=<cell with length>*<cell with height>

Eg. Let us assume we have a list of lengths of rectangles spread across column A from cell A3 to A11 and the heights of the rectangles spread across column B from B3 to B11. We need the area of the rectangle in column C from C3 to C11.

Now, the formula for the rectangle for C3 would become:

=A3*B3

You could use the Fill function to pull the formula down to C11. Simply click outside the cell C3 and back on it. Then use the fill button at the right bottom corner to pull the selection down to C11.

Calculate the area of a Triangle in Excel

The formula for calculating the area of a triangle is (length * height)/2. Thus, the syntax of the formula for finding the area of a triangle in Excel would become:

=(<cell with length>*<cell with height>)/2

Eg. Let us consider the length and height in columns A and B as in the previous example. We need the areas of the triangles in column D from D3 to D11.

Now, the formula for the triangles for C3 would become:

=(A3*B3)/2

You can use the Fill function as explained earlier to pull the formula down to D11.

Calculate the area of a Circle in Excel

The area of a circle is 3.14*(radius*radius). To create the formula in Excel, I could suggest the exponential function however, since the goal is just to find the square, we can twist the formula a little. The syntax to find the area of a circle in Excel is as follows:

=3.14*<cell with radius>*<cell with radius>

Eg, if we have the list of radii in column F from F3 to F11 and we need the areas of the circles in column G from G3 to G11, then the formula for cell G3 would become:

=3.14*F3*F3

You could use the Fill function to pull the formula down to cell G11.

Does this work?

Related posts

• Ku hagaaji Saddex Xagalka Jaallaha ah oo leh Barta Dhawaaqa ee Excel ama Word

• 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

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

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

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

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