Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Round Off

A B
7.5 8
8.2 8
9.5 10
3.7 4
7.4 7
7.7 8
Total 44 45
Please refer above example
I have some figures in column "A" it shold be rounded off , done in column
"B" what I want is aftrer rounding off toal increase by 1. that is before
round off total 44 ,after rounding off total 45. is there any way to round
off without affecting total. total sld remain unchanged

 
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
Round it off Sri Harsha[_2_] Excel Worksheet Functions 3 October 27th 09 12:59 PM
Round then round? pgarcia Excel Discussion (Misc queries) 5 September 8th 08 07:30 PM
@ROUND steph44haf Excel Worksheet Functions 4 October 23rd 06 02:06 PM
round up James Horton Las Vegas Excel Worksheet Functions 3 August 29th 06 09:07 AM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 10:50 AM


All times are GMT +1. The time now is 07:27 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"