Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-08-2019, 11:30 AM
Lamont Lamont is offline Windows Vista Office 2010
Novice
 
Join Date: Jan 2019
Posts: 1
Lamont is on a distinguished road
Default Rounding numbers in formulas

I found out how to round numbers in a cell. Apparently the numbers still contain the exact number in the cell because when using the rounded number in a formula I get results one would obtain using the exact number. How can I get the number used in the formula to use the rounded number?
Reply With Quote
  #2  
Old 01-08-2019, 01:58 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 409
ArviLaanemets will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 01-09-2019, 01:04 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

@Arvi
In your second example line there seems to be some confusion between dots and commas, or am I missing something ?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #4  
Old 01-09-2019, 08:19 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 409
ArviLaanemets will become famous soon enough
Default

Nothing strange with this - I use commas in numbers, and semicolons as separators. In this post I corrected some such 'typos', but it looks like missed 2nd row ones.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:51 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft