Rounding Problem
I have a requirement to displace the follwoing pair of data items as
shown:
A simple example is:
2.753, 2.848 ....... 2.75 / 85
I have the following formula:
=TEXT(2.753;"0.00")&" / "&TEXT((2.848-INT(2.848))*100;"00")
Obviously on the workbook the values as cell references
Using the follwoing example I get a 'wrong' result.
2.850 - 2.995 should be shown as 2.85 / 00, but is shown as 2.85 /
100.
I do not understand how 995 becomes 100 rtaher than 00, when the
format requested is "00", but it does.
Can anyone think of a way to achieve what I am looking for?
|