software

=IF(AH16=1,IF(SUM($AF16:AG16)=0,quot;███quot;,quot;quot;),quot;quot; )

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 quot;gggquot;, 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 quot;gggquot;. any clues?Your black box is unicode (9608) with an arial unicode MS font
--
Gary''s Studentquot;myquot; wrote:

gt; =IF(AH16=1,IF(SUM($AF16:AG16)=0,quot;███quot;,quot;quot;),quot;quot; )
gt;
gt; i have a formula as above (i am not the one who wrote the formula). the
gt; black bars you see in the formula are being treated as if they were text. i
gt; thought perhaps they might be symbols, but if i use, for example, the
gt; webdings font and i use quot;gggquot;, and the cell is formatted to be webdings font
gt; i get a similar result. but i would like to know how, whoever wrote this
gt; formula, made those black bars come out instead of say quot;gggquot;. any clues?
gt;

Choose an empty cell amp; use the Insertgt;Symbol 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 quot;Character codequot; 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.
quot;myquot; wrote:

gt; =IF(AH16=1,IF(SUM($AF16:AG16)=0,quot;███quot;,quot;quot;),quot;quot; )
gt;
gt; i have a formula as above (i am not the one who wrote the formula). the
gt; black bars you see in the formula are being treated as if they were text. i
gt; thought perhaps they might be symbols, but if i use, for example, the
gt; webdings font and i use quot;gggquot;, and the cell is formatted to be webdings font
gt; i get a similar result. but i would like to know how, whoever wrote this
gt; formula, made those black bars come out instead of say quot;gggquot;. any clues?
gt;