LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use and change special symbols in Excel Madhan Excel Discussion (Misc queries) 1 November 20th 06 04:47 PM
Excel Symbols randrews13 Excel Discussion (Misc queries) 2 May 23rd 06 04:34 AM
excel symbols ally Excel Worksheet Functions 1 May 14th 06 11:56 AM
Symbols in Excel Erika Excel Discussion (Misc queries) 4 December 9th 05 12:07 PM
Symbols in Excel Charts Symbols in Charts Charts and Charting in Excel 3 July 19th 05 02:51 AM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"