Forum Discussion
Nested IF formula
Hello Everyone: I have a total of 5 ranges of prices clasified by a alpha numeric code (IE: P5 from 1USD to 5 USD - P4 from 6USD to 10 and so on until P1 from 25 and above), and I have a data bas...
Hi
Your fomula has some definition holes.
If you are using whole numbers 10 and 15 are not definied.
If you are using decimal numbers a lot more is not defined.
Instead of nested IF() functions it is better to set up a lookup table (W1:X5). Column W has to be sorted in ascending order.
=LOOKUP(T6,$W$1:$W$5,$X$1:$X$5)