Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE
 

I would like to write an IF formula with the condition:
IF two or more values in a range of six values are <3 then state "true"

I only know how to conditon "if one number in a range is <3 then true. How
to do it when you want to know if there are at least two numbers that show <3?

=COUNTIF(A1:A6,"<3")2

Or, if you require Text instead of Booleans,

=IF(COUNTIF(A1:A6,"<3")2,"True","False")

Kind regards,

Niek Otten

"IFfunction" wrote in message
...
I would like to write an IF formula with the condition:
IF two or more values in a range of six values are <3 then state "true"

I only know how to conditon "if one number in a range is <3 then true. How
to do it when you want to know if there are at least two numbers that show
<3?

As an example

=IF(COUNTIF(A1:E1,"<3")1,"true","")

--
HTH

Bob Phillips

"IFfunction" wrote in message
...
I would like to write an IF formula with the condition:
IF two or more values in a range of six values are <3 then state "true"

I only know how to conditon "if one number in a range is <3 then true. How
to do it when you want to know if there are at least two numbers that show
<3?