<div class="raw-html-embed"><p>The <b>BASE</b> function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#mathtrigonometry" onclick="onhyperlinkclick(this)">math and trigonometry functions</a>. It is used to convert a number into a text representation with the given base.</p>
			<h5 class="pt8">Syntax</h5> 
			<p><b><em>BASE(number, radix, [min_length])</em></b></p> 
			<p>The <b>BASE</b> function has the following arguments:</p>
            <table style="width: 40%">
                <tbody><tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>number</em></b></td>
                    <td>A number you want to convert. An integer greater than or equal to 0 and less than 2^53.</td>
                </tr>
				<tr>
                    <td><b><em>radix</em></b></td>
                    <td>A base you want to convert the number to. An integer greater than or equal to 2 and less than or equal to 36.</td>
                </tr>
				<tr>
                    <td><b><em>min_length</em></b></td>
                    <td>A minimum length of the returned string. An integer greater than or equal to 0 and less than 256. It is an optional parameter. If the result is shorter than the minimum lenght specified, leading zeros are added to the string.</td>
                </tr>
            </tbody></table>
			
			<h5 class="pt8">Notes</h5>
			<p><a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>BASE</b> function.</p>
			
			<h5 class="pt8">Examples</h5>
            <p>The figure below displays the result returned by the <b>BASE</b> function.</p>
			<p><img alt="BASE Function" src="https://static-helpcenter.teamlab.info/base_baa234ea76.png"></p></div>

BASE function

Docs

Argument	Description
*number*	A number you want to convert. An integer greater than or equal to 0 and less than 2^53.
*radix*	A base you want to convert the number to. An integer greater than or equal to 2 and less than or equal to 36.
*min_length*	A minimum length of the returned string. An integer greater than or equal to 0 and less than 256. It is an optional parameter. If the result is shorter than the minimum lenght specified, leading zeros are added to the string.

BASE function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud