Prevent formula calculation past hundreths?

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.
 
P

Peo Sjoblom

=TRUNC(A1*6,1)

or



=ROUND(A1*6,1)


depending on how you want to treat different decimals



--


Regards,


Peo Sjoblom
 
J

J.W. Aldridge

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.
 
P

Peo Sjoblom

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
 
J

J.W. Aldridge

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.
 
P

Peo Sjoblom

Just beware that this can cause some grievances and it is
for all the values in a workbook

--


Regards,


Peo Sjoblom
 
Top