View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJ[_4_] AJ[_4_] is offline
external usenet poster
 
Posts: 14
Default Limit on logical function

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