ExcelBanter - Formula???

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula??? (https://www.excelbanter.com/excel-discussion-misc-queries/239036-formula.html)

Hi,
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 advise!

Try this:

=IF(SUMPRODUCT(--(O5:O20O22-4*D3))0,"BAD DATA",0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"John Sofillas" wrote in message
...
Hi,
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 advise!