Challenge #183: Roman Numeral Math

[TylerNa]

This was a tough one for me but I struggled my way through it. The help on the dynamic replace was a game changer.

Spoiler

[justindavis]

This one definitely took me the most time out of any of the ~60 weekly challenges I've completed thus far, but I'm glad it did because I picked up some new things - particularly the Dynamic Replace technique others have pointed out. Most notably, I'm glad to learn that...

Spoiler

... you don't need a macro to evaluate an expression stored in a field. You can just create a dummy field that contains the name of the field containing your expression, and use that one tool as the D and R inputs for the Dynamic Replace. Awesome!

[RWvanLeeuwen]

I learnt Dynamic Replace via @Martyn, so thank you 😄

Spoiler

I did not round the answer, as I did not see a cue that I should

[JonMcMillin]

Roman numerals took me back to primary school, nice little challenge!

Spoiler

[Greg_Murray]

Solution Attached

[JamesMA]

A very tough challenge, the logic in the multi-row formula is what gave me lots of trouble.

Some help from @DanielMS got me through it.

Spoiler

[delilah]

Spoiler

Two ways to get there.

[DataTester]

Was stuck at the very last step until I previewed the posted solution and learned about Dynamic Replace. This is a tool I'm going to be trying to use get better with in the future. Always great to learn a new tool.

[ganesamurthy]

Here is my version.

Spoiler