How to Use the LOG Function in WPS on Windows

Last updated:July 17, 2026

Use the LOG function through 3 how-to topics, all available directly in AirSheet, and follow the index to complete each task in order.

How-to Index

#TopicMembership
11. Enter the LOG function and view syntax guidanceFree
22. Complete a LOG formula calculationFree
33. Check results with references and recalculationFree

How-to Guide

1. Enter the LOG function and view syntax guidance

Entry point: Formulas tab → formula bar

  1. Open AirSheet and select the cell where you want to enter the formula.
  2. Type an equals sign = in the formula bar or directly in the cell.
  3. Continue by typing LOG(.
  4. Review the automatic syntax prompt to confirm the required arguments and example.

Success Criteria

  • UI state: A function prompt appears after you type LOG(.
  • Next actions: You can continue entering arguments and finish the formula.

Tips While Using

  • Common mistakes: If you do not start with =, the content may be treated as plain text.

2. Complete a LOG formula calculation

Entry point: formula bar or target cell

  1. Select the target cell and type =LOG(.
  2. Enter the correct arguments based on the prompt.
  3. Check that the parentheses and separators are complete.
  4. Press Enter to confirm the formula.
  5. Check whether the calculation result appears in the cell.

Success Criteria

  • UI state: The cell shows a calculated result instead of raw formula text.
  • Next actions: You can copy the formula, continue editing, or save the sheet.
  • No side effects: Existing content in other cells remains unchanged.

Tips While Using

  • Common mistakes: Mismatched parentheses, the wrong number of arguments, or missing separators can cause an error.

3. Check results with references and recalculation

Entry point: cell with the formula → formula bar

  1. Reference the cells that should be included in the LOG calculation.
  2. Combine LOG with other functions when needed to build a nested formula.
  3. Change the data in the referenced cells.
  4. Check whether the result updates automatically.
  5. If you want to verify the result manually, press F9 and review the updated value again.

Success Criteria

  • UI state: When referenced data changes, the result updates automatically or after recalculation.
  • Next actions: You can expand the formula to more rows and columns for batch calculations.

Tips While Using

  • Common mistakes: Referencing text-formatted numbers or the wrong cells can affect result accuracy.
  • Environment limits: The manual recalculation shortcut works when the current spreadsheet window is active.