ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tally marks (https://www.excelbanter.com/excel-discussion-misc-queries/119858-tally-marks.html)

CONFUSED!!

Tally marks
 
How do I make tally marks on Microsoft Excel??

Dave Peterson

Tally marks
 
Like if you're counting something...

I'd put the number in A1 and use this formula in B1:

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))



CONFUSED!! wrote:

How do I make tally marks on Microsoft Excel??


--

Dave Peterson

Mike Rogers

Tally marks
 
CONFUSED

Tell us what your deffinition of a "Tally Mark" is, are you counting? do you
want a check mark? an "X", tell us what you are trying to accomplish.

Mike Rogers

"CONFUSED!!" wrote:

How do I make tally marks on Microsoft Excel??



All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com