Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Use of "--" in functions??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jones the Scouse - 20 Nov 2006 21:37 GMT
I'm new to compiling and using functions of anything other than a
relatively simple basis.  I've been reading a lot of questions and
answers on this group and am amazed at some of the complex functions
that can be built up.

I am starting to understand most of them but keep seeing "--" used in
functions - why is this used?  Does it only apply to certain functions?
I've tried typing the some of the functions posted without them
because I thought they may just have been used to clarify the structure
of the function but have noted that the end result is different with
and without the dashes.

I've tried to look up what they are and where you would use them but
I've drawn a blank so far - I know that one of you guys will be able to
help me out.

Thanks.
Bernard Liengme - 20 Nov 2006 21:42 GMT
Used to force ('coerce') Boolean (true/false) result to numeric (1/0)
Details at http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> I'm new to compiling and using functions of anything other than a
> relatively simple basis.  I've been reading a lot of questions and
[quoted text clipped - 13 lines]
>
> Thanks.
Jones the Scouse - 20 Nov 2006 22:02 GMT
Bernard,

Thanks for that - it all makes sense now!  I'll also check out the link
that you refer to.

J-t-S

> Used to force ('coerce') Boolean (true/false) result to numeric (1/0)
> Details at http://mcgimpsey.com/excel/formulae/doubleneg.html
[quoted text clipped - 21 lines]
> >
> > Thanks.
Bob Phillips - 20 Nov 2006 23:19 GMT
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> I'm new to compiling and using functions of anything other than a
> relatively simple basis.  I've been reading a lot of questions and
[quoted text clipped - 13 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.