LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Help with Rounding total off but leaving .00

Hi all, this is probably quite simple but cannot find it, i need to
tally up a total and if it is 2541.512 then the answer should be 2542.00
and if it is 2541.425 then it must be 2541.00.

Any help much appreciated...

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
 
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
Leaving a total sum cell blank until other cells are filled Ric Crombie Excel Worksheet Functions 3 December 8th 09 02:29 PM
How do I get a formula total to quit rounding up in Excel? skmarshall Excel Discussion (Misc queries) 4 April 30th 08 04:38 PM
Why is a row's total rounding up? PHRed Excel Worksheet Functions 2 July 11th 06 04:28 PM
Rounding percentage's of the total jesterhs Excel Discussion (Misc queries) 5 July 26th 05 05:16 PM
Rounding parts of a number while maintaining the Total Susan Lammi Excel Programming 2 August 26th 03 05:30 PM


All times are GMT +1. The time now is 05:46 AM.

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"