Forum Discussion
IFS AND Function
Hey so I'm trying to create a column where depending on the amount of points a column would display Level 1, Level 2, Level 3 The point are distributed Level 1 (0 - 219) Level 2 (220 - 339) L...
Hey ive tried using the lookup table but it gives an error message. maybe cause it needs to be within the ranges and not just a match?
The value in J4 in the screenshot should have been 340 instead of 240, but the formula should work.
See the attached sample workbook.