Forum Discussion
michael_fasanof
Aug 07, 2024Copper Contributor
Sum function
I have an excel worksheet I use for Invoices to bill customers. When I sum the page, the rounded numbers are not added. Instead excel is adding the longer decimal version of the number which is causing my invoice totals to be a few cents off.
For example:
40*24.92+2.75*37.38+10*49.84 =
1,597.9950 |
And When I round up that number becomes 1,598.00 which is the number I want excel to add but instead it adds the longer version. I have been manually adding them with a calculator and typing in the correct sum. Is there any way to have excel add up my invoice amounts as shown.
5 Replies
Sort By
Do you want
=ROUNDUP(40*24.92+2.75*37.38+10*49.84, 2)
or
=ROUNDUP(40*24.92)+ROUNDUP(2.75*37.38, 2)+ROUNDUP(10*49.84, 2)
- michael_fasanofCopper ContributorThe number is rounded up on my worksheet that is not the issue. the issue is excel is adding the longer decimal version of the number which is causing my invoice totals to be a few cents off.
- Detlef_LewinSilver Contributor
Please explain:
What is the longer decimal version of 49.84?
What is the shorter decimal version of 49.84?
What is the normal decimal version of 49.84?
- michael_fasanofCopper Contributor