Forum Discussion
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 causi...
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)
The 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.
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?
Sorry, I don't understand what you mean.
