Trouble with Forumlas being used in EXCEL 97 file

[HOWARJLA]

I have been given a EXCEL File which contains several Formulas that I am not familiar with. I understand what the Forumla's do (I understand what a if function and etc do and how they work) however what does the "=+" and the "--" parts mean?


Below are some examples of forumla's being used. I marked the parts which I am unfamiliar with in red.

=+Operations!L44

=+IF(B18="Z",5,0)

=(((SUMPRODUCT(--($D$7:$D$24="supplier"),--($F$7:$F$24=75)))*75*3))+(((SUMPRODUCT(--($D$7:$D$24="supplier"),--($F$7:$F$24=50)))*50*3))


Any insight into what these items do/what they do to the formula would be greatly appreiciated.

 

[VoG]

The + are unnecessary

-- coerces an array of False/True to an array of 0/1 that SUMPRODUCT can process.

 

[HOWARJLA]

The + are unnecessary

-- coerces an array of False/True to an array of 0/1 that SUMPRODUCT can process.

Okay Thanks. I didn't think that the + signs were needed; but didn't want to go erasing a bunch of things.

Additional question;
So I think that the -- makes sense to me now. But that only works in reguards to the SUMPRODUCT funtion? or is it used in many other functions? I am not used to arrays out side of MACRO use.

Again. Many Thanks!

 

[VoG]

You could use this to coerce text into a time, for example

=--"10:15"