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?