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