sum off by 1or 2 cents

  • Thread starter Thread starter MK
  • Start date Start date
M

MK

When using excel to calculate pricing by increasing a
cost by a percent many times the end price is off by 1 or
2 cents. There has to be an easy answer that I am
overlooking. $1.78(cell ref)*1.2 = $2.13 Should be
$2.14
Help
Thanks
MK
 
Hi
try
=ROUND(A1,2)*1.2

Probably your cell reference is also a calculated value and only
displayed as a rounded figure
 
What is displayed in a cell is not necessarily what's really in there.
Formatting for decimals, for example, does not round the underlying value.
Often recommended is to round all cells explicitly (using the ROUND()
function).
I myself feel that for financial spreadsheets
Tools>Options>Calculation>Precision as displayed is a very useful option.
Keep in mind that the option only works for cells that are explicitly
formatted; mostly that is exactly what you require.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
When ever I add or subtract % I use the cell of the number times 1 plu
or minus the %. example =E6*(1+1%) or as for your case =1.76*(1+1%).
I found this formula in the excel help. I hope this helps.

To
 
Back
Top