See whether this simpler VLOOKUP gives you the desired returns:
=IF(D1=0,0,VLOOKUP(D1,{1,5;1001,4;25001,3;50001,2; 100001,1},2))
Expand the table array to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"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