ExcelFlux

BASE function

Conversion — a number into a text representation with the given radix (base).

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Display decimal device values as text in another base.

A worked example from the workbook

RowAB
6First valueSecond value
7152
83116
998
Record 1
=BASE(A7,B7)

Expected result1111

See the inputs and instructions for all 3 examples

Syntax

BASE(Number, Radix [Min_length])

Copyable formulas

English Excel · en-US
=BASE(15,2)
Turkish Excel · tr-TR
=TABAN(15;2)

Expected result

“1111”

Worked examples

Display decimal device values as text in another base.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 15 2
8 31 16
9 9 8
Case Formula Expected result
Record 1 =BASE(A7,B7) 1111
Record 2 =BASE(A8,B8) 1F
Record 3 =BASE(A9,B9) 11
Microsoft Excel reference