Expanding Range in Formula?

[John Sofillas]

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.

 

[NBVC]

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

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

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[M Thompson]

Hello-

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

Thanks

 

[David Biddulph]

Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html
b.. http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[John Sofillas]

Double unary minus:
  a..http://www.mcgimpsey.com/excel/formulae/doubleneg.html
  b..http://xldynamic.com/source/xld.SUMPRODUCT.html

--
David Biddulph

Hello-

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

:

- Show quoted text -

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