LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Rounding Numbers.

How can I round a number to two decimals. Not using the increase/decrease
decimals. For example...

I get an answer like this, 2.41666666666667, I know that if you lower the
decimals to two units, the cell will show the answer 2.42, but if I use this
cell in a calculation it will still use 2.41666666666667, and will give me an
incorrect answer.

100 * 2.41666666666667 = 241.6666667
100 * 2.42 = 242


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding numbers up or down boyshanks Excel Discussion (Misc queries) 13 April 8th 09 03:03 PM
rounding numbers in XL Sean Lambertz Excel Discussion (Misc queries) 4 May 30th 06 10:32 PM
Rounding numbers Phil Excel Discussion (Misc queries) 3 March 8th 06 09:35 PM
Rounding up numbers Michelle Nichols via OfficeKB.com Excel Discussion (Misc queries) 2 April 28th 05 05:03 PM
Rounding Numbers j41cam Excel Discussion (Misc queries) 1 April 18th 05 07:47 PM


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"