Posted to microsoft.public.excel.misc
|
|
Expanding Range in Formula?
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...d.php?t=122849
|