Thread: How do I do an IF with a range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default How do I do an IF with a range?
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
Reply With QuoteReply With Quote