Common questions about LOG usually focus on formula errors, nested usage, and result updates; this section includes 3 frequent questions and answers.
FAQ
What should I check if the LOG function returns an error?
- Check whether the parentheses, parameter order, and separators are correct.
- Confirm that the input values are suitable for numeric calculation.
- Save the formula again and review whether the error is cleared.
Can I use the LOG function together with other functions?
- Enter LOG in the formula field first.
- Combine LOG with other functions based on your table logic.
- Save the formula and review whether the final result matches your expectation.
Why does the result look wrong after I change the data?
- Check whether the referenced source field was updated successfully.
- Confirm that the formula is pointing to the correct values or fields.
- If an error message appears, fix the formula and review the result again.
Glossary
| Term | Definition |
|---|---|
| LOG | A function used to return a logarithmic value. |
| Formula field | A field type in WPS tables that accepts formulas and displays calculated results automatically. |
| Parameter | An input value used by a function during calculation. |