reduce decimal places of number used in formula

[CatzJ]

I use Excel 2000. I pulled a number with 5 decimal places into a contract,
reducing it to 3 decimal places. I then use that number in a formula to
figure a cost to be billed. I only want to use the 3 decimal number in the
formula. Is there a way for the formula to use the 3 decimals only without
having to actually re-type the number. I use this sheet monthly and would
like it to do it automatically.

 

[Bernie Deitrick]

Catz,

If your number is in cell A1, when you reference it, use

ROUND(A1,3)

So, instead of

=A1*100
use

=ROUND(A1,3)*100

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
=ROUND(your_number,3)