Convert kilograms to stones in Excel and Google Sheets
=CONVERT(A2,"kg","stone")
A2 = data cell
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Convert kilograms to stones in Excel
How to convert kilograms to stones in Excel?CONVERT KILOGRAMS TO STONES β EXCEL FORMULA AND EXAMPLE
=CONVERT(A2,"kg","stone")
A2 = data cell
Weight and mass units
Gram = "g"
Slug = "sg"
Pound mass (avoirdupois) = "lbm"
U (atomic mass unit) = "u"
Ounce mass (avoirdupois) = "ozm"
Grain = "grain"
U.S. (short) hundredweight = "cwt" or "shweight"
Imperial hundredweight = "uk_cwt" or "lcwt" ("hweight")
Stone = "stone"
Ton = "ton"
Imperial ton = "uk_ton" or "LTON" ("brton")
π‘ Detailed measurement units definition outlined here
Convert kilograms to stones in Google Sheets
How to convert kilograms to stones in Google Sheets?CONVERT KILOGRAMS TO STONES β GOOGLE SHEETS FORMULA AND EXAMPLE
=CONVERT(A2,"kg","stone")
A2 = data cell
Available unit conversions by category
Weight β u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton
Distance β ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec
Time β sec, min, hr, day, yr
Pressure β Pa, mmHg, Torr, psi, atm
Force β dyn, pond, N, lbf
Energy β eV, e, J, flb, c, cal, BTU, Wh, HPh
Power β W, PS, HP
Magnetism β ga, T
Temperature β C, F, K, Rank, Reau
Volume β ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3
Area β ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2
Information β bit, byte
Speed β m/hr, mph, kn, admkn, m/s
π‘ Detailed measurement units definition outlined here
- Convert kilograms to pounds
- Convert pounds to kilograms
- Convert stones to kilograms
- Convert acres to hectares
- Convert hectares to acres
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria