Expanding Range in Formula?
 

The formula below works the way I want it to for cell O5. How can I
open this formula up for a range of cells O5:O20?

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

As always, much appreciated for the advice.

Expanding Range in Formula?
 

=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

Expanding Range in Formula?
 

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

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

Expanding Range in Formula?
 

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!