Round Number to Chosen Places
Round number to decimal places; exact ties go away from zero.
Your numbers
Value after rounding
Use consistent units. Result follow the assumptions wey you enter.
Compare scenarios
You fit keep up to three snapshots for this tab. Loading one go replace the present inputs.
Formula
Use R = sign(x)round(abs(x)×10^p)/10^p. x na value and p na decimal places. abs mean absolute value; sign dey restore di sign. Halfway cases dey round away from zero; negative places dey round to bigger place values.
Round number to decimal places; exact ties go away from zero.
Example wey show the calculation
- Value wey e get
- 123.456
- Decimal places; negative value round to tens and higher
- 2
- Value after rounding
- 123.46
Where e fit work and limits
Use consistent units. Result follow the assumptions wey you enter.
We check inputs for missing values and allowed ranges. Result wey pass the finite numeric range no go show. Rounding affect wetin display, while calculation use the model numeric precision.
Check your units and assumptions before you rely on result. Changing label no convert currency or physical unit.
Version of di formula: 812ed1ed8b2a · Example don get check: