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)
