Tally marks in an excel worksheet
Is there a way to use a tally mark type system in an excel spreadsheet?
|
Do you mean have 7 in a cell (say A1) and have:
||||| || show up in B1 (say). If yes, then try a formula like: =REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5)) You'll see something like: †††† || (nice if you're using Arial--not sure how it'll show up in the newsgroup, though.) jkahn wrote: Is there a way to use a tally mark type system in an excel spreadsheet? -- Dave Peterson |
All times are GMT +1. The time now is 02:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com