=IF(AH16=1,IF(SUM($AF16:AG16)=0,"–ˆ–ˆ–ˆ",""),"" )

i have a formula as above (i am not the one who wrote the formula). the
black bars you see in the formula are being treated as if they were text. i
thought perhaps they might be symbols, but if i use, for example, the
webdings font and i use "ggg", and the cell is formatted to be webdings font
i get a similar result. but i would like to know how, whoever wrote this
formula, made those black bars come out instead of say "ggg". any clues?

Your black box is unicode (9608) with an arial unicode MS font
--
Gary''s Student


"my" wrote:

=IF(AH16=1,IF(SUM($AF16:AG16)=0,"–ˆ–ˆ–ˆ",""),"" )

i have a formula as above (i am not the one who wrote the formula). the
black bars you see in the formula are being treated as if they were text. i
thought perhaps they might be symbols, but if i use, for example, the
webdings font and i use "ggg", and the cell is formatted to be webdings font
i get a similar result. but i would like to know how, whoever wrote this
formula, made those black bars come out instead of say "ggg". any clues?

Choose an empty cell & use the InsertSymbol menu option. Be sure to use the
font that your workbook uses and search through the different symbols
available. When you find one you want to use, clcik on it. Note at the
bottom of the symbol window there's a "Character code" box. Make a note of
the number in that box and Cancel the dialog

Now, to enter that symbol, whether in a cell by itself or in the middle of a
formula, hold down the Alt key and USING THE NUMERIC KEYPAD, type the number.



"my" wrote:

=IF(AH16=1,IF(SUM($AF16:AG16)=0,"–ˆ–ˆ–ˆ",""),"" )

i have a formula as above (i am not the one who wrote the formula). the
black bars you see in the formula are being treated as if they were text. i
thought perhaps they might be symbols, but if i use, for example, the
webdings font and i use "ggg", and the cell is formatted to be webdings font
i get a similar result. but i would like to know how, whoever wrote this
formula, made those black bars come out instead of say "ggg". any clues?