Need "true" or "false"
 

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

Need "true" or "false"
 

Hi Vicky

Look at this:

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

Regards,
Per

"Vicky" skrev i meddelelsen
...
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

Need "true" or "false"
 

Hi Vicky

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

"Vicky" wrote:

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

Need "true" or "false"
 

It works perfectly,

Thanks a lot!!!!
vicky

"Eduardo" wrote:

Hi Vicky

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

"Vicky" wrote:

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

Need "true" or "false"
 

Another one:

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



Vicky wrote:

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

--

Dave Peterson