Have you ever needed to use Roman numerals and just typed them in manually? What happens when you need to type in a value of 100? Do you know the Roman numeral for that?
There is a very simple solution:
=ROMAN (number, [form])
- number – Number (in Arabic numeral) you want to convert to Roman numeral.
- form – [optional] The type of Roman numeral you want.
You can type in =ROMAN(4) which will return “IV”, or you can reference a cell like I have done in the image. =ROMAN(D6) which will return “I”
Quick, easy and cuts out having to lookup the correct Roman numeral.