=IF(SUM((D3:H3100)*(D3:H3<200)),"Neg","OK")

Use Ctrl+Shift+Enter after pasting in formula bar.

On Nov 26, 3:19 pm, Marcelo wrote:
Hi,
I need to find in a range if I have a certain value (100 and <200) I was
trying =IF(AND(D3:H3100,D3:H3<200),"OK","Neg")
but it give me the error: #value!
How do I do this?
Thanks
--
Marcelo