Am trying to get a value best on my if conditions but every time my the value in Cell GV2 is 40 and above i get a false yet i want it to be DIV 2 here is the code
=IF(AND(GV2="DIV 4",GD2>=60),"U",IF(AND(GV2="DIV 4",GD2<=59),"DIV 4",IF(AND(GV2="DIV 3",GD2>=52),"DIV 4",IF(AND(GV2="DIV 3",GD2<=51),"DIV 3",IF(AND(GV2="DIV 2",GD2>=45),"DIV 3",IF(AND(GV2="DIV 2",GD2<=44),"DIV 2",IF(AND(GV2="DIV1",GD2>=33),"DIV 2",IF(AND(GV2="DIV 1",GD2<=32),"DIV 1"))))))))
CodePudding user response:
Well, corrected the typos and it works:
Note, you are testing cell GD2 for the number and cell GV2 for the text as per your IF() statement, but in your question text you seem to be confused.