Microsoft Office Forums Rounding numbers in formulas
 Register FAQ Search Today's Posts Mark Forums Read

#1
01-08-2019, 11:30 AM
 Lamont Windows Vista Office 2010 Novice Join Date: Jan 2019 Posts: 1
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?
#2
01-08-2019, 01:58 PM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 770

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
#3
01-09-2019, 01:04 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,669

@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
#4
01-09-2019, 08:19 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 770

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.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post knewman Excel 14 04-25-2017 11:54 PM paulkaye Excel 8 09-03-2016 11:12 PM melissapete24 Excel 5 08-27-2016 12:51 AM Guloluseus Excel 5 10-27-2015 11:28 PM required_username Excel 10 06-05-2014 05:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:46 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top