When using ROUND, the most common questions fall into 3 areas: formula errors, nested usage, and automatic recalculation; this FAQ covers 3 frequent questions plus a glossary.
FAQ
What should I check if ROUND returns an error?
- Check whether the parentheses, commas, and field references are complete.
- Make sure the input field is numeric instead of plain text.
- Save the formula again and see whether the error message remains.
Can I use ROUND with other functions?
- Start with a basic ROUND formula.
- Then use ROUND as an argument in another function, or pass another function result into ROUND.
- Save the formula and review the output row by row.
Does ROUND update automatically after source data changes?
- Formula fields usually recalculate when source data changes.
- Edit one source value and check whether the rounded result changes too.
- If it does not, confirm that the formula references the correct field.
Glossary
| Term | Definition |
|---|---|
| ROUND | A function that rounds a number to a specified number of digits. |
| Formula field | A field type in a multidimensional table that generates results automatically from a formula. |
| Argument | An input in a function that defines what to calculate and how to calculate it. |