I need a formula that would do the following: If the value in cell X is Y, show Z. I have about 80 or so relationships between Y and Z.
Z is a percentage, but not one that is calculated so it is text, and Y is never an integer.
So, for example, let's say the value in cell X is 8.9. Anything equal to or greater than 8 but less than 9 needs to show 67%. Anything equal to or greater than 7 but less than 9 needs to show 65%. And so on and so on. How do I do this?