Formula HELP!!

%3CLINGO-SUB%20id%3D%22lingo-sub-293892%22%20slang%3D%22en-US%22%3EFormula%20HELP!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293892%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20assistance%20greatly%20appreciated%2C%20So%20I%20have%20col%2Frow%20which%20is%20formatted%20as%20True%20and%20False.%3C%2FP%3E%3CP%3EIf%20The%20first%20col%20is%20False%26nbsp%3B%20the%20next%20is%20true%20and%20the%20next%20is%20False%2C%20then%20the%20result%20should%20be%20Risk%2C%20however%2C%20if%20the%20first%20col%20is%20false%20and%20the%20next%20is%20True%20and%20the%20next%20is%20true%20then%20the%20result%20would%20be%20No%20Risk%2C%20so%20I%20have%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND((W3%3D%22FALSE%22)%2C(X3%3D%22TRUE%22)%2C(Y3%3D%22FALSE%22))%2C%22Risk%22%2CIF((W3%3D%22FALSE%22)%2C(X3%3D%22TRUE%22)%2C(Y3%3D%22TRUE%22))%2C%22No%20Risk%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20working%2C%20any%20idea%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-293892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Any assistance greatly appreciated, So I have col/row which is formatted as True and False.

If The first col is False  the next is true and the next is False, then the result should be Risk, however, if the first col is false and the next is True and the next is true then the result would be No Risk, so I have 

 

=IF(AND((W3="FALSE"),(X3="TRUE"),(Y3="FALSE")),"Risk",IF((W3="FALSE"),(X3="TRUE"),(Y3="TRUE")),"No Risk")))

 

Not working, any idea?

 

 

0 Replies