Thread: Multi-value IF formula?

Hi all,

I know how to do a 2 value IF statement, but not 3 values. Here is the end result I am after for column U, carrying cost:

• Carrying Cost ($U). Based on product sales rank and unit dimensions:
○ Sales rank ($K) of less than 5,000 = $0.15*(($L*$M$*$N)/1728)
○ Sales ranks 5,001 - 25,000 = $0.35*(($L*$M$*$N)/1728)
○ Sales ranks 25,001 or greater = $0.50*(($L*$M$*$N)/1728)

I think Excel will have a way of doing this but am not sure. Any advice is appreciated!

Andrew's CHOOSE() formula will work just fine.
For general info should you ever have bigger tables to work from it's usually then advisable to build a lookup table for the bands and values and read the 0.15, 0.35, 0.5 etc. values with a VLOOKUP()