WPS Features
Resources
Free AI Tools
Docs Center

How to Use the LOG Function in WPS on Windows

Last updated:July 13, 2026

Use the LOG function through 3 how-to topics: inserting it from the Insert Function dialog, typing it directly in a cell, and reviewing syntax and parameter details before use.

How-to Index

No.TopicMembership Requirement
11. Insert LOG through the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Insert LOG through the Insert Function dialog

Entry point: Formulas 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 Formulas tab.
  3. Search for LOG in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • Interface result: The target cell now contains the LOG function.
  • What you can do next: You can continue editing parameters, confirm the formula, or copy it to other cells.

Tips While Using

  • Make sure the parameters use valid numeric values.
  • The base argument is optional; if you leave it blank, confirm the calculation logic you want to use in the sheet.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =LOG(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter guidance, type =LOG( and press F1.

Success Criteria

  • Interface result: The cell returns a calculation result and the full formula remains visible in the formula bar.
  • What you can do next: You can drag the fill handle to apply the formula to more cells.

Tips While Using

  • Separate formula arguments with English commas.
  • If the result looks incorrect, check whether the referenced cells are stored as numbers.

3. Review syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter LOG in the search box.
  3. Select the function and review the syntax: LOG(number, [base]).
  4. Click the help link for the function to view more details.

Success Criteria

  • Interface result: You can see the LOG function name, syntax, and parameter area.
  • What you can do next: You can return to the worksheet and continue inserting or editing the formula.

Tips While Using

  • The number argument should be a positive number.
  • Before confirming parameters, check the calculation goal and the base setting.