Thread: stumped ??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
my
 
Posts: n/a
Default stumped ??

=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?