Nested IF statements formula

How the formula works

1. The first IF statement checks if A1 is greater than or equal to 1. If it is, then it moves on to the next IF statement. If it's not, then it returns an empty cell ("").
2. The second IF statement checks if A1 is less than 2. If it is, then it returns 92.5% (which is 0.925 as a decimal). If it's not, then it moves on to the next IF statement.
3. The third IF statement checks if A1 is less than 3. If it is, then it returns 95% (which is 0.95 as a decimal). If it's not, then it moves on to the next IF statement.
4. The fourth IF statement checks if A1 is less than 4. If it is, then it returns 97.5% (which is 0.975 as a decimal). If it's not, then it returns 100% (which is 1 as a decimal).

So, if A1 is 1.5, the formula will return 92.5%. If A1 is 2.5, the formula will return 95%. If A1 is 3.5, the formula will return 97.5%. And if A1 is 4.5 or greater, the formula will return 100%.