I am using this formula:
=IF(SUMPRODUCT((ABS(D$17:D$70)>=8)+0),"ERROR","OK")
However, I don't want the formula to evaluate D20&D21.
When I try to use this range- .....((ABS(D17:D19,D22:D70)>=8).....
it tells me I have too many arguments?
The formula itself works perfect, I use it on another sheet. But to fit the current application I need to exclude thes 2 cells.
Any Ideas?
Thanks for your time and help.
=IF(SUMPRODUCT((ABS(D$17:D$70)>=8)+0),"ERROR","OK")
However, I don't want the formula to evaluate D20&D21.
When I try to use this range- .....((ABS(D17:D19,D22:D70)>=8).....
it tells me I have too many arguments?
The formula itself works perfect, I use it on another sheet. But to fit the current application I need to exclude thes 2 cells.
Any Ideas?
Thanks for your time and help.