Hi,

Somewhere out of the way creat a table with your threshold values and what
you want to return similar to the table below. I used A1 - B5

Then the formula
=VLOOKUP(AH8,A1:B5,2,TRUE)
For any number uo to 10000 this will return zero and at 10001 it starts
returning 5. Add all the thresholds you want but ensure the left column must
remain sorted ascending.

0 0
10001 5
25001 4
50001 3
100001 2


Mike

"AJ" wrote:

I need to add 5 more conditions to my statement below. I have tried and I
can only enter 3 more before I get an error. Does anyone have any
suggestions for a work around or a better way to enter the formula?

=IF(AND(AH8<=10000,AH80),5,IF(AND(AH8=10001,AH8< =25000),4,IF(AND(AH8=25001,AH8<=50000),3,IF(AND(A H8=50001,AH8<=100000),2,IF(AND(AH8=0),0,1)))))
--
AJ