Truncate a number before rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I've got a calculation the yields the following result...

1.0549

I've used the following formula to get this result
=Round(([x]/[y]),4)
x= 96
y= 91

I would like to drop the "9" and then apply banker's type rounding to the
remaining digits (1.054), resulting in 1.0. Is it possible to drop the 9
without affecting the numbers to the left of it? If so, how can it be done?
Thanks in advance for any advice.
 
Ken,

Thank you very much. Your recommendation worked beautifully.
--
Somecallmejosh


Ken Sheridan said:
Try this:

Int(TheNumber*1000)/1000

Ken Sheridan
Stafford, England

Joshua K Briley said:
Hello,

I've got a calculation the yields the following result...

1.0549

I've used the following formula to get this result
=Round(([x]/[y]),4)
x= 96
y= 91

I would like to drop the "9" and then apply banker's type rounding to the
remaining digits (1.054), resulting in 1.0. Is it possible to drop the 9
without affecting the numbers to the left of it? If so, how can it be done?
Thanks in advance for any advice.
Click to expand...
Click to expand...
 
Back
Top