You can nest if statements inside each other, but just because you can doesn’t mean you should! A better option is to use IFS. This allows you to specify conditions and what you want to do when those conditions are met, in a way that is much easier than nesting if statements inside each other.
The general layout of IFS is =IFS(condition, value if true, [condition, value if true]…). For each condition you specify, you need to give a value if that condition is met. You can set as many as these pairs as you want (well up to 127! which if you are doing that many I think there are better options – xlookup for example.)
You need to be careful with the order that you put the conditions. Once a condition is met then the value is assigned and the function stops. For example, if you want to assign A to values over 90, then put that first, because if you put the values over 70 first, then 90 will get caught by that condition. You can enter TRUE as the last condition and put a value in to pick up anything that hasn’t met one of the other conditions, so a value will always be returned rather than an error.
