Good Afternoon,
Here is my first post, I hope i can Make myself Understood,
I have six possible results 1,2,3,4,5,6
If a cell A1 is between 97 and 100, result must be 1
If the same cell is between 85 and 96.99, result must be 2
If the same cell is between 70 and 84.99, result must be 3
If the same cell is between 50 and 69.99, result must be 4
If the same cell is between 20 and 49.99, result must be 5
If the same cell is between 0 and 19.99, result must be 6
I have the formula =IF(A1>=97, "number 1","number 2")
But That is good for a boolean result, how can I adapt that for 6 results? Thankyou
and
=IF(A1>=97, "number 1", IF(A1>=85, "Number2", IF(A1>50, "Number 3", "Number 4")))
But I would need it to be
=IF(A1=100 or is greater than 97), "Number1", OR IF(A1=85 but less than 96.99), "Number2", OR IF(A1=70 but less than 84.99), "Number3", OR IF(A1=50 but less than 69.99), "Number4", OR IF(A1=20 but less than 49.99), "Number5", OR IF(A1<20), "Number6"
Thanks for your help.
Bookmarks