"Tally" or "Five-Bar Gate" function?

[William Phillip Michael Hunt]

Hello everyone,
I was wondering if there existed a function for making five-bar gate type
representations of numbers...
You know, where it goes | || ||| |||| and then |||| but struck
out, then a new group starts. (Totally useless for more than about 20, but
dead handy for smaller figures.)
Anyone have a ready-made solution? If not, I'll try and do one and post
it at the group. (But it'll take a while what with work and all...)
Cheers,
Greg Fox

[Myrna Larson]

I don't know how you plan to do the "strike out" bit. In this example, I used
a back slash as the 5th character

=TRIM(REPT("||||\ ",INT(A1/5))&REPT("|",MOD(A1,5)))

[Harlan Grove]

William Phillip Michael Hunt <gre...@hotmail.com> wrote in message
news:8462ac$a46$1...@newsg2.svr.pol.co.uk...

> Hello everyone,
> I was wondering if there existed a function for making five-bar gate
type
> representations of numbers...
> You know, where it goes | || ||| |||| and then |||| but struck
> out, then a new group starts. (Totally useless for more than about 20, but
> dead handy for smaller figures.)

Try this:

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

In Arial, 17 becomes ???? ???? ???? || . If you want a more vertically
centered strikethrough, you're on your own.

[Gregory L Fox]

Thanks, that's really great. Have an excellent new year.

[Gregory L Fox]