Truncate a number before rounding

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top