"IF" formula?
Hi, hoping someone can help me. I am trying to make a sheet that reads analysis-results for me, i have different parameters within different intervals. The result varies between different intervals - giving them a surtain "class". F. eks, my result is 12. The different classes are 1: <8, 2: 8-20, 3: 20-50, 4: 50-600 and 5: 600-1000. (1: very good, 2: good, 3: moderate, 4: bad, 5: very bad) Hence this is a class 2: good. How do i write the formula so that the formatted cell tells me which interval my result is in? ( it would be great to show the result not only in number, but maybe also with color? As the different classes are marked by colors.) I have attatched my excel sheet.