"Philip J Smith" wrote in message
...
Hi Bob.

Thanks for the alternative syntax, it worked first time!

What does the "--" do?

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.


GESTEP is an engineering function. e.g. GESTEP(A,B)= 1 if A=B I use it
instead of IF(A=B,1,0) to avoid nested if functions when a binary (0,1)
result is required

So it is. I have never seen it before, didn't know it was a built-in. I
assumed it was a UDF <g. I'll remember that one.