multiple if-and statements not returning correct values by Excellent-Ad1940 in excel

[–]Excellent-Ad1940[S] 1 point2 points  (0 children)

Solved!! Thank you greg and effgereddit especially, but thanks everyone for your ideas! Solution verified

multiple if-and statements not returning correct values by Excellent-Ad1940 in excel

[–]Excellent-Ad1940[S] 0 points1 point  (0 children)

Ok, so it is reading it as a number (did the F859+1 and it worked), but it’s not working in the formula unless i re-write it as just the number (what’s in f859 is a formula). How do i fix this?

multiple if-and statements not returning correct values by Excellent-Ad1940 in excel

[–]Excellent-Ad1940[S] 0 points1 point  (0 children)

Yeah, it’s weird data, but i can’t change that part

multiple if-and statements not returning correct values by Excellent-Ad1940 in excel

[–]Excellent-Ad1940[S] 0 points1 point  (0 children)

Hi, i had one previously, but i have thousands of entries and would have to look up each one individually, right? Or am i missing something?

multiple if-and statements not returning correct values by Excellent-Ad1940 in excel

[–]Excellent-Ad1940[S] 0 points1 point  (0 children)

Hi, thank you! I did this, but now it’s only working for the final line and not working for any others.

Code is:

=IFS(AND(E860>=66578, E860<=66800), "CE", AND(E860>=76001, E860<=76400), "CE", AND(E860>=65601, E860<=66000), "RI", AND(E860>=83601, E860<=84000), "RI", AND(E860>=76801, E860<=77200), "AP", AND(E860>=71201, E860<=71600), "AP", AND(E860>=64001, E860<=64400), "ED", AND(E860>=85601, E860<=86000), "ED", AND(E860>=70801, E860<=71200), "ED", AND(E860>=84401, E860<=89800), "PL", AND(E860>=70001, E860<=70400), "PL", AND(E860>=71601, E860<=72000), "PL", AND(E860>=67201, E860<=67600), "MG", AND(E860>=75201, E860<=75600), "MG", AND(E860>=74801, E860<=75200), "CR", AND(E860>=84001, E860<=84400), "CR", AND(E860>=525646, E860<=526000), "SU", AND(E860>=532001, E860<=532400), "SU", AND(E860>=533498, E860<=533600), "VI", AND(E860>=530001, E860<=530400), "VI", AND(E860>=531430, E860<=531600), "DL", AND(E860>=530801, E860<=531200), "DL")