Formulas > =DECIMAL()
How to Use DECIMAL() in Google Sheets
Description
How To Actually Use DECIMAL() in Sheets
DECIMAL(value, base)
Try DECIMAL yourself
In cells A1:A5, enter binary numbers (e.g., 101, 1101). Use the DECIMAL function in cell B1 to convert the binary number in A1 to decimal. Drag the formula down to B5 to convert all binary numbers.
Hints (2)
-
Remember to specify the base of the binary numbers.
-
You can use the fill handle to copy the formula down.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the DECIMAL() formula:
Generate a DECIMAL() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses DECIMAL(). 2 free AI generations, no signup. Members get unlimited use.
Generate a DECIMAL() formula