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

I

IFfunction

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

Niek Otten

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