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

How do I do an IF with a range?
 

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

How do I do an IF with a range?
 

=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

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