When using BASE, the most common questions fall into 3 areas: error handling, result checking, and batch use; this section includes 3 FAQs and a glossary.
FAQ
What should I do if BASE returns #VALUE!?
- Check whether any argument contains text, spaces, or other unexpected content.
- Make sure the arguments used in the calculation are valid numeric values.
- If needed, clean the source data and enter the formula again.
Why does the BASE result not match what I expected?
- Check whether the referenced cell is correct.
- Confirm that the radix argument matches the target base you want.
- Review the argument order and check the function syntax again.
How can I use BASE in multiple cells at once?
- Enter the BASE formula in the first target cell.
- Select that cell and drag the fill handle across the target range.
- Add
$to references if you need to lock part of the formula.
Glossary
| Term | Definition |
|---|---|
| BASE | A function that converts a number into a text representation in a specified base. |
| radix | The base argument that defines the target number system for the returned text. |
| min_length | An optional argument that sets the minimum length of the returned text and pads it with zeros at the front when needed. |