WPS Features
Resources
Free AI Tools
Docs Center

How to Use the LOG10 Function in WPS on Windows

Last updated:July 13, 2026

Follow 3 operation topics to use LOG10 in WPS Spreadsheet on Windows: insert it from the function dialog, type it directly in a cell, and review the syntax and parameter description.

How-to Index

No.TaskAccess
11. Insert LOG10 from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review the syntax and parameter descriptionFree

How-to Guide

1. Insert LOG10 from the Insert Function dialog

Entry path: Formula tab → Insert Function

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

Expected result

  • What you should see: the target cell contains a LOG10 formula and shows a calculated result.
  • What you can do next: edit the argument, copy the formula, or fill it down.

Notes

  • Common mistake: a misspelled function name can make the search fail.
  • Limitation: the argument should be a valid numeric value for calculation.

2. Type the formula directly in a cell

Entry path: Worksheet cell → Formula bar

  1. Select the target cell.
  2. Type =LOG10(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, drag the fill handle or copy and paste the formula to other cells.

Expected result

  • What you should see: the cell returns the corresponding logarithm result.
  • What you can do next: edit the formula, adjust references, or apply it to more cells.

Notes

  • Common mistake: an unclosed parenthesis or a nonnumeric argument can cause an unexpected result.
  • Limitation: when copying the formula, check whether relative references move as intended.

3. Review the syntax and parameter description

Entry path: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for LOG10.
  3. Select the function and review the syntax LOG10(number).
  4. Confirm the parameter meaning before finishing the formula entry.

Expected result

  • What you should see: the function name, syntax, and parameter description are visible.
  • What you can do next: return to the worksheet and enter or revise the formula.

Notes

  • Common mistake: entering the formula before checking the parameter requirement can lead to an unexpected result.
  • Limitation: the help text explains the function, but the final result still depends on the value you enter.