Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stumped - How to report most recent line/row? | Excel Discussion (Misc queries) | |||
Stumped by a lookup scenario | Excel Worksheet Functions | |||
Completely stumped for formula | Excel Discussion (Misc queries) | |||
Simple But Stumped | Excel Discussion (Misc queries) | |||
Stumped! Collecting values into one cell. | Excel Worksheet Functions |