I am creating a decision tool using IF statements. If cell L24 states either "ASU" or "ASU & Life" and Cell H39 states "Unemployed" I require the cell to produce a negative value ("Not OK"), if this criteria isn't produced then I need a positive value to be produced ("OK").
I am creating the formula in a seperate sheet of the same worksheet, the Cells I refer to are in the sheet named "Form".
=IF(Form!H39="Unemployed",AND(OR(Form!L24="ASU","ASU & Life"),"Not OK","OK"))
I have the above so far but keep getting either FALSE or a #Value result. I have tried changing the AND/OR around but I can't get the dual criteria in L24 to work.
Any help would be greatly appreciated
Bookmarks