Challenge #235: Spell It Out For Me - Part 2

[LHolmes]

I took a very non-dynamic, although extremely simple, route that will work for amounts less than one billion.

Spoiler

Two tools.

[hlmess]

I made this as dynamic as I could think to with the only assumption being that we won't go below the cent level.

It's needlessly complicated and there are many potential improvements but it's very flexible as is with nothing really hardcoded. 

Spoiler

[Tony_Castillo]

Spoiler

There's commonality between field logic:
1 & 4 & 7
2 & 5 & 8
3 & 6
Seems there is a solution with Dynamic Replace somewhere but don't have the time for a second solution. The attached solves the challenge. Looking forward to seeing more efficient ways to solve from the community.

[ggruccio]

Spoiler

I created the logic for cents, then dollars and hundreds of dollars, then repeated for thousands and millions.

[TonyA]

Here's my solutions. Not hard to get an answer, but it's pretty tedious. I sacrificed some efficiency in an effort to make this easier to follow. Next step would be to adjust "dollars" and "cents" to account for "one dollar" or "one cent." to do that I would probably test the original values from the first exercise instead of mucking around with the number broken into columns.

Spoiler

[ngaskill1]

After having gone through the exercise, I probably could reduce the number of formulas but this works with just a few tools.

Spoiler

[Nicholas_Norton]

Spoiler

After a while, I gave up and used @RolandSchubert's solution as a reference. I'll have to try again after a couple days and see if I can do it on my own.

This one was hard for me, but fun.

[Kenda]

Spoiler

[Qiu]

Man, that is a lot of Formula...

Spoiler

[DaisukeTsuchiya]

Wokflow could be simplified more. Used formula is not complicatd but many tool are used.

Spoiler