— CAN YOU SOLVE THIS - EXCEL CHALLENGE 121 —
(Solutions in any language are also welcome for Excel Challenges)
Calculate Digital root of the given numbers. This is also known as Digital Sum, Seed Number, Numerological Sum.
Sum all digits such that final sum reduces to a single digit.
25 = 2+5 = 7
59 = 5+9 = 14 = 1+4 = 5
5638 = 5+6+3+8 = 22 = 2+2 = 4.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dtJ8wEAW
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post