Home > database >  i dont know why am getting a false value
i dont know why am getting a false value

Time:07-09

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: enter image description here

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.

  • Related