Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Thank you,
Quite a good one, 8 steps including the app inputs, all native functionality and no macros required.
Use 'Generate Rows' to determine the maximum that the base divides into the Decimal
Determine the modulo of the divisor to get effectively a key for that character position
Replace that key with the 0-9A-F character depending on the base
Concatenate back together, reversing the string
Here is my solution:
Then they will get combined in the analytics app for output:
I went for multi-row calculation to handle reminders. Additional input can be implemented for user to choose what number to convert.
My answer attached.
Macro:
Submitting my first weekly problem solution!
I made an iterative macro to handle the conversion:
And used it in an analytic app so the user can input an integer and a base and see their number converted:
Any feedback is welcomed :)