FORMULAS
Auto-Converting Units with CONVERT()
5 min read · Template referenced below
If you're retyping the same feet-to-meters math into a calculator every time you update a takeoff sheet, Excel already has a function built for this: CONVERT(). Set it up once and every dependent cell updates automatically.
1
Enter your base value.
Put your source measurement in a cell — say, A2 for a length in feet.
2
Write the CONVERT formula.
In the target cell: =CONVERT(A2,"ft","m") converts feet to meters instantly.
3
Swap units as needed.
Change "ft" and "m" to any supported unit pair — "in", "yd", "cm", "mm" all work the same way for length. Weight units like "lbm" (pounds) and "kg" work identically.
Need a quick one-off conversion instead of building it into a sheet? BuildQuantify's
Unit Converter handles length, area, volume, and weight instantly in the browser.
This scales cleanly across an entire takeoff sheet: drag the formula down a column and every row converts on its own — no separate calculator app needed.
Back to all tutorials →