Thread
:
Rounding numbers in formulas
View Single Post
01-08-2019, 01:58 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 932
ROUND(YourFormula,n), where returned comma places depends on n.
=ROUND(22.111,0) returns 22. =ROUND(22.555,0) returns 23
=ROUND(22,111,2) returns 22,11 =ROUND(22,555,2) returns 22,56
=ROUND(22,-2) returns 20 =ROUND(25,-2) returns 30
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets