Saamiga miisaanka ilaa dhererka iyo BMI waa halbeegyo muhiim ah oo lagu cabbirayo caafimaadka aasaasiga ah ee qofka. Haysashada diiwaanka xuduudahaan waa muhiim iyadoo la tixgelinayo xulashada ciyaaraha, xulashada shaqada, ilaalinta diiwaanka caafimaadka, yoolalka caafimaadka shakhsi ahaaneed, iwm.

Habka xisaabinta BMI ee Excel

Haddii aad rabto inaad xisaabiso miisaanka ilaa dhererka saamiga iyo BMI gudaha Excel , akhri maqaalkan.

Waa maxay Tusaha Cuska Jirka^{(Body Mass Index)} & sababta ay muhiim u tahay?

Habka xisaabinta BMI waa miisaanka qofka oo loo qaybiyay dhererka labajibbaaran.

BMI=weight/(height*height)

Halka ay dhammaan tirooyinka loo baahan yahay inay ahaadaan halbeeg mitir ah, ie miisaanka kiiloogaraam iyo dhererka mitirka.

Qiyaasta BMI waa sida soo socota:

• Ka hooseeya 18.5 = Miisaan yar
• 18.5 ilaa 24.9 = Caadi
• 25 ilaa 29.9 = Miisaan badan
• Ka sarreeya 30 = buuran

Sababta xisaabinta BMI ay muhiim u tahay waa in ^(BMI)BMI ay tahay halbeeg caalami ah oo la aqbalay oo lagu xisaabinayo khatarta cudurrada wadnaha iyo macaanka. Qofka cayilan waxa uu leeyahay 50% in ka badan fursadaha uu ku qaadi karo xanuunka macaanka, qofka buuran waxa uu leeyahay in badan oo ka badan fursadaha xanuunka macaanka iyo cudurrada caafimaadka.

Sida loo xisaabiyo miisaanka ilaa dhererka saamiga gudaha Excel

Ereyga lagu xisaabinayo miisaanka iyo dhererka saamiga ee Excel waa sida soo socota:

=<first cell with the value of weight in kilograms>/<first cell with the value of height in meters>

Halkee,

• <Uunugga koowaad oo leh qiimaha miisaanka kiiloogaraam> waa unugga ugu horreeya ee ka gudba hal tiir oo miisaanka lagu sheegay.
• <unugga koowaad oo mitirka qiimihiisu yahay> waa unugga ugu horreeya ee ka gudba hal tiir oo dhererka lagu sheegay.

Tusaale ahaan. Haddii miisaanka kala duwan ee laga soo sheegay unugga B3 ilaa B11 iyo dhererka C3 ilaa C11 , oo aad u baahan tahay liiska miisaanka iyo dhererka saamiga ee tiirka E, geli caanaha soo socda ee unugga E3:

=B3/C3

Kadib, waxaad isticmaali kartaa shaqada Buuxinta^(Fill) si aad u soo jiid caanaha ilaa E11 . Kaliya^(Simply) dhagsii meel ka baxsan unugga aad ku gashay qaacidada ka dibna dib ugu celi unugga. Guji^(Click) dhibicda yar ee ku taal geeska hoose ee midig ee unuggaas oo adoon sii deynin gujinta, u jiid taxanaha hoos ilaa E11 .

Sida loo xisaabiyo saamiga BMI ee Excel

BMI waa tilmaame wanaagsan oo lagu qiimeeyo caafimaadka shakhsiga. Habka xisaabinta BMI ee Excel waa sida soo socota:

=first cell with the value of weight in kilograms>/(Power(<first cell with the value of height in meters>,2))

Tusaale ahaan. Aynu tixgelinno tusaalihii hore, iyadoo ay ku kala duwan yihiin inaan u baahanahay tirada BMI^(BMIs) ee tiirka G. Kaliya Geli^{(G. Simply Enter)} caanaha unugga G3:

=B3/(Awoodda(C3,2))

Ka dib qaacidada hoos ugu soo jiid unugga G11 adigoo isticmaalaya shaqada Buuxinta^(Fill) .

Rajo inay ku caawiso!

Calculate BMI in Excel using this BMI calculation formula

The weight to height ratio and BMI are important parameters for measuring thе baѕic health of a person. Keeping a record of these parameters is important while сonsidering sports selections, job selections, health record-keeping, personal heаlth goals, etc.

BMI calculation formula in Excel

If you wish to calculate the weight to height ratio and BMI in Excel, read through this article.

What is Body Mass Index & why is it important?

The formula for calculating the BMI is the weight of a person divided by height square.

BMI=weight/(height*height)

Where all the quantities need to be in metric units, i.e. weight in kilograms and height in meters.

The range for BMI is as follows:

• Below 18.5 = Underweight
• 18.5 to 24.9 = Normal
• 25 to 29.9 = Overweight
• Above 30 = Obese

The reason BMI calculations are important is that BMI is a globally accepted parameter for calculating the risk of heart diseases and diabetes. An overweight person has 50% more chances of developing diabetes and an obese person has many times more the chances of diabetes and health diseases.

How to calculate the weight to height ratio in Excel

The syntax to calculate the weight to height ratio in Excel is as follows:

=<first cell with the value of weight in kilograms>/<first cell with the value of height in meters>

Where,

• <first cell with the value of weight in kilograms> is the first cell across a single column where the weight has been mentioned.
• <first cell with the value of height in meters> is the first cell across a single column where the height has been mentioned.

Eg. If the range of weights has been mentioned from cell B3 to B11 and heights from C3 to C11, and you need the list of the respective weight to height ratios in column E, the insert the following formula into cell E3:

=B3/C3

Then, you can use the Fill function to pull the formula down to the E11. Simply click outside the cell in which you entered the formula and then back on the cell. Click on the little dot at the bottom-right corner of that cell and without releasing the click, pull the sequence down to E11.

How to calculate BMI ratio in Excel

BMI is a better index for judging the health of an individual. The syntax for calculating BMI ratio in Excel is as follows:

=first cell with the value of weight in kilograms>/(Power(<first cell with the value of height in meters>,2))

Eg. Let us consider the previous example, with the difference that we need the range of BMIs in column G. Simply Enter the formula in cell G3:

=B3/(Power(C3,2))

Then pull the formula down to cell G11 using the Fill function.

Hope it helps!

Related posts

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Xisaabi Iskucelceliska Dhaqdhaqaaqa Fudud, Miisaan, iyo Sarbeeb

• Sida loo Helo loona Xisaabiyo Range gudaha Excel

• Xisaabi Tilmaanta Tirada Jirka (BMI) adoo isticmaalaya xisaabiyeyaasha BMI ee bilaashka ah ee PC

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo Rept Function gudaha Excel

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

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

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

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

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

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel