How do I sum rounded values from two seperate formulas in Excel?

G

Guest

I am using an Excel spreadsheet for a payroll function that relies on
seperate formulas to calculate personal services and mileage reimbursement.
The two areas are paid with different checks so they need to be seperate.
However, in order to balance there must also be a calculated total. I
formated the cells so 'currency' is used and two decimal points are
displayed. But, when the two cells are summed, they are summed on actual
values and not the displayed rounded values. The problem is obvious . . . you
cannot pay someone $57.125 so it needs to be rounded to a paid amount of
$57.13 . . . but how do I get Excel to sum on $57.13 and not $57.125?

Thanks for any help or suggestions.
 
B

Bob Phillips

=SUM(ROUND(A1:A20,2))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Stop Excel from displaying rounded values 4
How do I sum cells that have values from a text formula? 4
How do I get "auto sum" to subtract hidden cell values from total 3
How do I round off times in Excel? 5
How do I get the rounded values from excel to a word document. 1
Different results from like formulas 2
How do I add up the last 12 cells (containing values) in a column. 4
Nest 3 SUMPRODUCT formulas - Possible? 7

Top