J
JB
I am having trouble with some reports in excel that due to
rounding are appearing a penny or two off. (see below)
Due to the fact that this information is being presented
to several parties... I need the pennies to visually add
up.
The example below come up with a total of $36,910.27...
but if you add up the pennies on a calculator, it will add
up to $36,910.28.
Can this be done in a formula? Each row itself is a total
from another spreadsheet
$1,296.79
$1,499.40
$4,500.00
$4,968.98
$4,000.00
$6,593.71
$5,896.08
$3,451.82
$4,703.50
TOTAL $36,910.27
The total is actually correct... but It does not appear to
be... I need it to appear to be correct ($36,910.28).
Thanks for your help.
rounding are appearing a penny or two off. (see below)
Due to the fact that this information is being presented
to several parties... I need the pennies to visually add
up.
The example below come up with a total of $36,910.27...
but if you add up the pennies on a calculator, it will add
up to $36,910.28.
Can this be done in a formula? Each row itself is a total
from another spreadsheet
$1,296.79
$1,499.40
$4,500.00
$4,968.98
$4,000.00
$6,593.71
$5,896.08
$3,451.82
$4,703.50
TOTAL $36,910.27
The total is actually correct... but It does not appear to
be... I need it to appear to be correct ($36,910.28).
Thanks for your help.