Thread: How do I do an IF with a range?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I do an IF with a range?
Try this:

=IF(FREQUENCY(D3:H3,{199,100}),"OK","Neg")

--
Biff
Microsoft Excel MVP


"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


Reply With QuoteReply With Quote