My problem is that the sum results are rounded up please see example below
(I have used the exact figures I am having a problem with as an example)
cell f33, Invoice total 2,134.33
cell f35, less 2%=42.68 (but my excel keeps rounding it up to 42.69) and obviously this then alters the rest of the invoice figures.
I have read and tried clicking on "set precision as display" and also tried formating the cell to all different things including moving the decimal point and have had no luck what so ever and its driving me crazy ! I have resorted in doing the calculation on a calculator and then added the amount as text.
my contractors and accountant will not except the rounded up amounts on my invoices ?
if anyone could help please let me know cause I'm loosing sleep over it now lol
Bookmarks