More than 7 If Statements

  • Thread starter Thread starter mhunt
  • Start date Start date
M

mhunt

I have an existing formula that I would like to add the
following If Statement to (I am running Excel 2000):

IF((RIGHT(AG23,3)="LIC"),"License - Ren. N/A"),

Here is the existing formula (I want the statement above
to be the first parameter):

=IF(AH25<100,(VLOOKUP(AG25,PricingUS,2,FALSE)),IF(AH25>99,
(VLOOKUP(AG25,PricingUS,3,FALSE)),IF(AH25>499,(VLOOKUP
(AG25,PricingUS,4,FALSE)),IF(AH25>999,(VLOOKUP
(AG25,PricingUS,5,FALSE)),IF(AH25>1999,(VLOOKUP
(AG25,PricingUS,6,FALSE)),IF(AH25>4999,(VLOOKUP
(AG25,PricingUS,7,FALSE)),IF(AH25>9999,(VLOOKUP
(AG25,PricingUS,8,FALSE)),"See Pricing Table")))))))

Any help would be greatly appreciated.
 
Hi
7 nested functions is the maximum.
But try the following:
1. create a lookup table (e.g. on the sheet 'lookup') for the
row_index:
A B
0 2
100 3
500 4
....

Now use the formula
=VLOOKUP(AG25,PricingUS,VLOOKUP(AH25,'lookup'!$A$1:$B$10,2),FALSE)

Now add your additional IF clause
 
Back
Top