WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

Use BASE through 3 how-to topics, including entering it from Insert Function, typing the formula directly, and checking syntax details; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter BASE from the Insert Function dialogFree
22. Type a BASE formula directly in a cellFree
33. Check BASE syntax and argument detailsFree

How-to Guide

1. Enter BASE from the Insert Function dialog

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for BASE in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter the required arguments in the Function Arguments dialog.
  6. Click OK to insert the function.

Success Criteria

  • The selected cell now contains the BASE function.
  • The worksheet returns a calculation result after the arguments are confirmed.
  • The formula can be edited or copied to other cells.

Tips While Using

  • Search with the English function name BASE.
  • Separate arguments with commas.

2. Type a BASE formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =BASE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm the formula.
  4. If you need syntax help, type =BASE( and press F1 to view the function prompt.

Success Criteria

  • The cell shows the BASE calculation result.
  • The full formula is visible in the formula bar.
  • The formula can be filled down or copied to other cells.

Tips While Using

  • Keep the equals sign = at the beginning of the formula.
  • If the result looks wrong, check the argument types and parentheses first.

3. Check BASE syntax and argument details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for BASE.
  3. Select the function to view the syntax: BASE(number, radix, [min_length]).
  4. Click the help link for more details about the function.

Success Criteria

  • The full BASE syntax is visible.
  • Required and optional arguments are clearly identified.
  • You can continue entering or revising the formula with the correct argument order.

Tips While Using

  • number and radix are the main arguments, and min_length is optional.
  • Confirm the argument order and target base before revising a formula.