Miles and Yards to Miles and Chains, but......... not allowed to use macros

[Fireman_Simon]

Hi all, I am attempting to convert a cell that contains miles and yards into miles and chains (railway).

Examples of cell data I have:
113.121 = 113m 121yds.
114.0198 = 114m 198yds
116.0066 = 116m 66yds

As you can see, they are messy and the digits after the decimal point isn't a mantissa in the normal sense.

So, to get the first example converted I would ignore the characteristic every time. I just need to treat the mantissa as whole numbers ie; ignore 113m. Then work on the mantissa of 121. => 121yds/22 = 5.5 chains
All I need is the answer in chains to be rounded to the nearest whole number, so I can use the ROUND function after I get the answer: 6 chains
Finally, I reinclude the characteristic and would have 113.6 ie 113m 6chains

I'm an excel smoothbrain folks. I would love it if you are able to help me. No macros allowed I'm afraid.

Thanking you in advance, Simon.

 

[Fluff]

In that case how long is 111.12?
12yds, 120yds or 1200yds & how would you tell?