Remember Me?

#1
July 6th 07, 08:26 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 26
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,

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

Thanks,

Kevin

#2
July 6th 07, 08:44 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,397
Special symbols in Excel worksheets?

If you find a list with all of the special symbols, please post it so we can
find it.
the specific difference between countif and if, is that the criteria in
countif if is not a cell reference, needs to in a text format, (why I don't
know) In the if statement the equation is fine.

(By the way you would have problems with both of your example equations)

"Leonhardtk" wrote:

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,

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

Thanks,

Kevin

#3
July 6th 07, 09:12 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 26
Special symbols in Excel worksheets?

Ooops! I meant TODAY(), but was in a hurry.

Kevin

"bj" wrote:

If you find a list with all of the special symbols, please post it so we can
find it.
the specific difference between countif and if, is that the criteria in
countif if is not a cell reference, needs to in a text format, (why I don't
know) In the if statement the equation is fine.

(By the way you would have problems with both of your example equations)

"Leonhardtk" wrote:

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, "<" &TODAY()-90)
but in IF,

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

Thanks,

Kevin

#4
July 7th 07, 12:06 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,908
Special symbols in Excel worksheets?

A brief list of these symbols(operators) can be found in Help "about calculation
operators" and/or " types or operators"

The \$ sign operation/meaning can be found under "absolute cell references"

Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 12:26:04 -0700, Leonhardtk
wrote:

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,

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

Thanks,

Kevin

#5
July 7th 07, 12:27 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
Special symbols in Excel worksheets?

A few more under wildcards, and some others under format - custom
formatting.

Pete

On Jul 7, 12:06 am, Gord Dibben <gorddibbATshawDOTca wrote:
A brief list of these symbols(operators) can be found in Help "about calculation
operators" and/or " types or operators"

The \$ sign operation/meaning can be found under "absolute cell references"

Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 12:26:04 -0700, Leonhardtk

wrote:
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,

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

Thanks,

Kevin- Hide quoted text -

- Show quoted text -

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 09:06 AM.