Hello,
Hope my excel tips are helping you out.
Here is Today’s tip for you. Hope this help you.
If ever we want to Convert a Number into ROMAN
Value, then use ROMAN Command to Convert the same.
What Does It Do ?
This function produces a number shown as Roman numerals in
various formats.
How to use it ?
'=ROMAN(NormalNumber,RomanNumberFormat)
For example, please check the images.
Bonus Tip :
The Roman Number Format can be any of the following.
·
0 is Classic. This is used if no format is specified.
·
1 is more Concise.
·
2 is even more Concise.
·
3 is even more Concise still.
·
4 is Simplified.
·
TRUE is Classic
·
FALSE is Simplified
Hope the Tip is found interesting to you and the same is clear.
Looking forward for a feedback.
If any of your friend is also interested for the said excel Tips
, then asked them to fill the form by clicking on the below mentioned link:
If you have something that you want to share with the group,
please write to excelms.tips@gmail.com
Thanks & Regards,
CA Mohit Bansal
Excel Enthusiast
+91-9045773456
No comments:
Post a Comment