=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?