Hello,

Is it possible to build a formula that has 3 possible outcomes depending on the outcome of a certain sum. I tried to build something like an IF inside another IF but it always gives the third option, no matter what the value is. It has to work something like this, if a number in a specified cell is below 10 give "A", if its between 11 and 20 give "B", if its between 20 and 30, give "C".

I hope anybody can help me out with this!