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?