Syntax Question

[rexschwartz]

Hello! I cannot figure out the formula to "FLAG" (in separate columns) if a row does not meet these criteria:

- If e2= "TRUE", then c2="TRUE" and d2="TRUE"
- If d2= "TRUE", then c2="TRUE"
- If c2= "FALSE", then d2="FALSE" and "e2="FALSE"
- If c2= "TRUE"and either f2 OR g2="TRUE", then d2="TRUE"

Please let me know if you can help! Thank you

 

[Joe4]

Welcome to the Board!

Are you saying you want 4 formulas, one for each instance, and to return "FLAG" if each condition is not met?

Also, are the values enter in columns C, D, and E the TEXT values of "TRUE" and "FALSE", or the Boolean values of "TRUE" and "FALSE"?
If you aren't sure, assuming that C2 has one of these values in it, enter this formula in any blank cell and let us know what it returns:
=ISNONTEXT(C2)