I used the same approach in solving the challenge as provided in the solution. Learned a ton! Thank you.
Spoiler
I did it the long inefficient way with more lines to process than others, as sqrt approach caused my brain too much pain. However I learnt some new functions thanks to reviewing the official answers - ABS() and mod(). borrowed some formatting to lay it out nicer and break up the logic.
This was a really good challenge, that had me scratching my head, more about the Prime calculations than macros!
Just don't use a number over ~6 digits! Could definitely be improved to deal with bigger numbers.
Created analytic app solution where it finds closest prime number < Number
Spoiler
Just for reminder for future me to remember to tick this box so that it'll show up in the analytic app results
Tested with other values to see if it works
