How to Use the LOG Function in WPS on Windows

Last updated:July 23, 2026

Use the LOG function through 3 how-to topics, with 3 free topics and 0 membership-related topics, and jump from the index to the matching steps below.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use LOGFree
22. Enter a LOG formula with the right parametersFree
33. Review and use the calculated resultFree

How-to Guide

1. Create a formula field and use LOG

Entry path: Add Field → Formula → Formula editor

  1. Open the table that you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes LOG in the formula editor.
  5. Click Confirm to save the field settings.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the LOG formula in the formula editor.

Tips While Using

  • Common mistake: If you do not create a formula field first, entering a function in a regular field will not return a formula result.
  • Environment note: You need edit permission for the current table.

2. Enter a LOG formula with the right parameters

Entry path: Formula editor → function input area

  1. Enter LOG in the formula editor.
  2. Add the required parameters in the function format shown in the editor.
  3. Fill in the values or references needed for the calculation.
  4. Check that parentheses, commas, and parameter order are correct.
  5. Save the formula after reviewing the input.

Success Criteria

  • Interface result: The LOG formula can be saved in the editor.
  • Next action available: After saving, you can return to the table and review the result.

Tips While Using

  • Common mistake: Unclosed parentheses, incorrect parameter order, or unsuitable input values can cause formula errors.
  • Environment note: The referenced fields should support numeric calculation.

3. Review and use the calculated result

Entry path: Table records → formula result column

  1. Return to the table after saving the LOG formula.
  2. Review the formula result in the matching record.
  3. Change related source data and check whether the result updates.
  4. Reuse the result in later analysis or table logic if needed.

Success Criteria

  • Interface result: The formula field displays a calculated result.
  • Next action available: The result refreshes when the source data changes.

Tips While Using

  • Common mistake: A formula field is not meant for direct manual result entry.
  • Environment note: The displayed result depends on whether the source data meets the calculation conditions.