Functions and formulars

Hi WBT​,

First of all, I want to clarify the fact that in your explanation you have said that if the value in cell B14 is between:

• 30 and 49  --> then the word Pink should be placed in cell B13
• 17 and 33  --> then the word Purple should be placed in cell B13

But between these two cases there is a wrong logic because if in cell B14, for example, the number 32 was placed, which result do you expect to come out of the formula: pink or purple? For this reason, I have set the data range for the word Purple between the numbers 17 and 29. In this case, try the following formula.

=LOOKUP(B14, {0,9,17,30,50}, {"Yellow","-","Purple","Pink","-"})

In the formula, I have set "-", for cases when the numbers placed in cell B14 are outside the range of values ​​that you have requested for the formula to work. Of course, in the above formula I have considered that only positive numbers will be placed in cell B14 (including the number zero).

I hope I was clear in my explanation and I hope my formula works for you.

IlirU