Challenge #79: Find the Closest Prime Number

[ponraj]

Here is my solution!

Spoiler

Prime Number - MacroWorkflow

[JoshuaGostick]

My solution :)

Spoiler

[Karam]

Solution attached. Interesting challenge!

Spoiler

[Kenda]

Spoiler

This one was fun.
I didn't go with the macro route. I just made the assumption that the prime number would occur within 11 plus or minus the given number. I then add a row for each number below that set of numbers and find the ones where the module is 0 only once. Then to find the closest, I take the difference between that list and the given number and keep only the lowest difference.


P.S. the community page isn't letting me post the .yxwz file so I had to export it before attaching to this post.

[TonyA]

Here's my solution. I'm sure I could tighten this up but even as is I'm getting results for 10 digit numbers in under 3 seconds.

[hanykowska]

I liked this one :)

[RolandSchubert]

My solution

[KMiller]

Solution attached. One macro for higher numbers and one for lower.

Spoiler

[OllieClarke]

Went for an iterative macro to brute force this. Fun challenge :-)

Spoiler

[Greg_Murray]

Solution attached