| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel column sum, part 2
OK, I appreciate your speedy response. However, help!
Please add these for me and then give me the formula. I'm working iwth paryoll and the 1 cent off is driving me crazy. 64.58, 15.10, 126.00, 24.91 this should equal - 230.59 the way the formula is now the total is 230.60. It's driving me nuts. thank you, kandyr |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel column sum, part 2
Use the ROUND function to round your values to 2 decimal places.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kandyr" wrote in message ... OK, I appreciate your speedy response. However, help! Please add these for me and then give me the formula. I'm working iwth paryoll and the 1 cent off is driving me crazy. 64.58, 15.10, 126.00, 24.91 this should equal - 230.59 the way the formula is now the total is 230.60. It's driving me nuts. thank you, kandyr |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel column sum, part 2
See http://www.mcgimpsey.com/excel/pennyoff.html
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kandyr" wrote in message ... OK, I appreciate your speedy response. However, help! Please add these for me and then give me the formula. I'm working iwth paryoll and the 1 cent off is driving me crazy. 64.58, 15.10, 126.00, 24.91 this should equal - 230.59 the way the formula is now the total is 230.60. It's driving me nuts. thank you, kandyr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Hybrid Mode
