Excel: Primitive Bar Graph and Roman Numerals

Excel has a repeat function called REPT that will repeat a text character any number of times.  It’s format is REPT(TEXT, Value) where Value is the number of times that TEXT is repeated.  You can use “i”, “o”, “-“, or any other letters/symbols as your text and do a primative bar graph.  You can also your numbers to roman numerals if they are less than 4000 by using the ROMAN function.  The example table below shows three columns A, B, and C.  Row 7 shows the formulae starting with cell A7.  The rest of the rows show values if they formulae are copied down.

A B C
7 =Repeat(“i”,A7) =Roman(A7)
8 iiiiiiii VIII
9 iiiiiiiii IX
10 iiiiiiiiii X
11 iiiiiiiiiii XI
This entry was posted in Excel, software and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *