View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Leonhardtk Leonhardtk is offline
external usenet poster
 
Posts: 26
Default Special symbols in Excel worksheets?

You folks (that answer our dumb questions) are brilliant. Having said that,
many times the answer to a question ( the sample provided) includes some
strange symbols (such as --, or &, $$, etc). How can I find a list of these
symbols and whey they need to be used?

FOr example, when doing a COUNTIF with Dates I have to do:
=COUNTIF(a1:a50, "<" &DATE()-90)
but in IF,
=IF(a1:a50, < DATE()-90,Bad,Good)

NOt sure why I need quotes and & in COUNTIF but not in IF?

Thanks,

Kevin