IF command for >7times?

[Guest]

hi. I have a requirement to use this IF command for 15 times, since column G
is a value in my database which ranges from 500 to 75000 and i need to
organise it in 15 different bands like 500-999, 1000-1499 etc

I can use this formula for 7 times:

IF(AND(G19>=500,G19<=999),$D$4,IF(AND(G19>=1000,G19<=1499),$E$4 etc
D4, E4 etc are medians of the range. for e.g. D4 in this case = 750

How do i tackle this for 15 nested IF fucntions?

Pls help

 

[Brendan Reynolds]

If this were an Access question, the answer would be to use the Choose or
Switch functions instead of the IIf function. But the cell reference
indicates that this may be an Excel question, and I have no idea whether
Excel has Choose and/or Switch functions. If I am correct that this is an
Excel question, you might get a better answer in an Excel forum rather than
an Access one.

 

[Mike Painter]

hi. I have a requirement to use this IF command for 15 times, since
column G is a value in my database which ranges from 500 to 75000 and
i need to organise it in 15 different bands like 500-999, 1000-1499
etc

I can use this formula for 7 times:

IF(AND(G19>=500,G19<=999),$D$4,IF(AND(G19>=1000,G19<=1499),$E$4 etc
D4, E4 etc are medians of the range. for e.g. D4 in this case = 750

How do i tackle this for 15 nested IF fucntions?

Use a lookup