|
|
|
|
#1
01-08-2019, 01:58 PM
|
|||
|
|||
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 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically generate formulas from just the row numbers (auto insert the column) | knewman | Excel | 14 | 04-25-2017 11:54 PM |
| Custom rounding up | paulkaye | Excel | 8 | 09-03-2016 11:12 PM |
 Excel Seems to be Rounding Twice Rather Than Once
|
melissapete24 | Excel | 5 | 08-27-2016 12:51 AM |
| Rounding to nearest 0.25 | Guloluseus | Excel | 5 | 10-27-2015 11:28 PM |
| Rounding values inconsistent | required_username | Excel | 10 | 06-05-2014 05:35 AM |
Windows 8 
Office 2016
Hybrid Mode