Need "true" or "false"

[Vicky]

Hi All,

I need the column f2 to show whether it is true or false.....
Below is the scenario....
A1 B1 C1 D1 E1 F1(result)
s s s s s
s s y s y

I need the formula for F1 (result) so that from column A:E, if it is all
"s", the result should be "true", if column A:E, even i column has y, the
result should be "false"

Thanks in advance!!!

Vicky

 

[Per Jessen]

Hi Vicky

Look at this:

=IF(COUNTIF(A1:E1,"=s")=5,TRUE,FALSE)

Regards,
Per

 

[Eduardo]

Hi Vicky

=IF(AND(A1="S",B1="S",C1="S",D1="S",E1="S"),"True","False")

 

[Vicky]

It works perfectly,

Thanks a lot!!!!
vicky

Hi Vicky

=IF(AND(A1="S",B1="S",C1="S",D1="S",E1="S"),"True","False")

 

[Dave Peterson]

Another one:

=countif(a1:e1,"S")=5

Hi All,

I need the column f2 to show whether it is true or false.....
Below is the scenario....
A1 B1 C1 D1 E1 F1(result)
s s s s s
s s y s y

I need the formula for F1 (result) so that from column A:E, if it is all
"s", the result should be "true", if column A:E, even i column has y, the
result should be "false"

Thanks in advance!!!

Vicky