| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Rounding total off but leaving .00
Just use this formula, and format the cells to Number with 2 decimal
=ROUND(A1,0) -- -John Please rate when your question is answered to help us and others know what is helpful. "Les Stout" wrote: 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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Rounding total off but leaving .00
format(application.Round(number,0),"#,##0.00")
if you using a formula in a cell =Round(sum,0) format the cell for #,##0.00 -- Regards, Tom Ogilvy "Les Stout" wrote: 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 *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Rounding total off but leaving .00
Thanks John Much Appreciated, great evening.. :0)
Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Rounding total off but leaving .00
Thanks for the reply Tom & both versions...
Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving a total sum cell blank until other cells are filled | Excel Worksheet Functions | |||
| How do I get a formula total to quit rounding up in Excel? | Excel Discussion (Misc queries) | |||
| Why is a row's total rounding up? | Excel Worksheet Functions | |||
| Rounding percentage's of the total | Excel Discussion (Misc queries) | |||
| Rounding parts of a number while maintaining the Total | Excel Programming | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
