Conditonal Test

[jim]

Hi:

Can I use an IF function or an AND function or combination
of the two to create a conditonal test for more than two
elements. I need to expand my formula below to increase
the arugments > the two I'm currently using.

=IF(AND(E2=TRUE,G2=TRUE),TRUE,FALSE)

For example if I have 4 cells that all have "TRUE" I want
to return TRUE, all other combination within the 4 cells
should return FALSE.

So if cells C1, D1, E1, F1; all contain TRUE my test is
TRUE, if for example I have TRUE; FALSE; TRUE; TRUE it
fails, etc.

Thanks,

Jim

 

[John Wilson]

jim,

This should work:

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

Be careful with using "True" in a cell as it's a boolean value.

John

 

[john favalessa]

you're on track...the AND function can take up to 30
parameters (logical tests)!

 

[Dave Peterson]

One more option:

=IF(COUNTIF(C1:F1,TRUE)=4,"all true","not all true")