Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2019, 11:30 AM
Lamont Lamont is offline Rounding numbers in formulas Windows Vista Rounding numbers in formulas Office 2010
Novice
Rounding numbers in formulas
 
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 Rounding numbers in formulas Windows 8 Rounding numbers in formulas Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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 Rounding numbers in formulas Windows 7 64bit Rounding numbers in formulas Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@Arvi
In your second example line there seems to be some confusion between dots and commas, or am I missing something ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 01-09-2019, 08:19 AM
ArviLaanemets ArviLaanemets is offline Rounding numbers in formulas Windows 8 Rounding numbers in formulas Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
Rounding numbers in formulas 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft