CODEWITHSUNDEEP
excelif-statement
Intel Power
Intel Power

Reputation: 29

i dont know why am getting a false value

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"))))))))

Upvotes: 0

Views: 25

Answers (1)

Solar Mike
Solar Mike

Reputation: 8375

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.

Upvotes: 1

Related Questions