maybe?
=IF(AND(sum(D3:H3)=100,sum(D3:H3)<200),"OK","Neg" )


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Marcelo" wrote in message
...
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