Spreadsheet Rounding functions
Article ID: KB0080530
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.1 and higher |
Description
This article introduces spreadsheet functions for rounding.
Issue/Introduction
Spreadsheet Rounding functions
Environment
Windows
Resolution
1. Function Round: Round(x, n)
Returns the number x rounded to n decimal places. Use negative n to round to nearest 10, 100, etc.
2. Function RoundEven: RoundEven(x, n)
Returns the number x rounded to n decimal places, breaking ties by rounding half to even (Banker's Rounding.) Use negative n to round to nearest 10, 100, etc.
Feedback
Yes
No
Powered by
