On Aug 6, 3:12*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Double unary minus:
* a..http://www.mcgimpsey.com/excel/formulae/doubleneg.html
* b..http://xldynamic.com/source/xld.SUMPRODUCT.html

--
David Biddulph

"M Thompson" wrote in message

...



Hello-

Can I ask what is the purpose of the two dashes in the formula?

Thanks
--
OneFineDay

"NBVC" wrote:

=IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0)

This will return "Bad Data" if any value in O5:O20 is greater
thanO22-4*D3

--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:
http://www.thecodecage.com/forumz/sh....php?t=122849- Hide quoted text -

- Show quoted text -

Thanks again for the great support. Formula was exactly what I was
looking for. Much appreciated!