This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
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 :)