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: 446

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 Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,381

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

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

All times are GMT -7. The time now is 08:22 PM.

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