— CAN YOU SOLVE THIS - EXCEL CHALLENGE 154 —
(Solutions in any language are also welcome for Excel Challenges)
Convert from Roman to Decimal.
For conversion from Roman to Decimal Number, value of characters to be used - M-1000, D-500, C-100, L-50, X-10, V-5 & I-1.
Example - for MCLXVI
1000 + 100 + 50 + 10 + 5 + 1 = 1166
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/dfrGDgKx
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post