Prevent formula calculation past hundreths?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

In a cell, I have A1 which is $3.003999 (a result of another formula)

In B1, I have A1*6.

Excel is picking up the ".003999" thus giving me the result of $18.02.

Although I have A1 formatted to show $3.00 (to the hundredths), of
course it doesnt affect the calculations.

What can I do to get a clean $18.00 result?

I want accuracy, but not to the point past the hundredths.
 
=TRUNC(A1*6,1)

or



=ROUND(A1*6,1)


depending on how you want to treat different decimals



--


Regards,


Peo Sjoblom
 
Thanx, but if the result in A1 actually had change (i.e. $3.01), I
wouldnt want it to round down to $3.00.

Just limit the calculations to the hundredths.
 
Just use if on A1 before the multiplication is done

=TRUNC(A1,2)*6

It wasn't 100% clear that you wanted to remove the decimal beyond the 100ths
in A1 in your first post

--


Regards,


Peo Sjoblom
 
Thanx.

But I just came across the solution.


From the Menu: Tools=>Options=> Precision as displayed.


This way if there is change showing, it calculates. Just not the
numbers (thousandths etc) past that.

Thanx again for the try.
Appreciate it.
 
Just beware that this can cause some grievances and it is
for all the values in a workbook

--


Regards,


Peo Sjoblom
 
Back
Top