View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie kassie is offline
external usenet poster
 
Posts: 515
Default IF and AND statement

An IF formula can only handle 7 if's.
You will have to change your tactics here, and either se something like
VLOOKUP, an array, or a second column, if you want to go beyond 7 IF's

--
HTH

Kassie

Replace xxx with hotmail


"Ward" wrote:

Hi,

Please can you let me know why this formula works:

=IF(AND(A10,A1<99),"First",IF(AND(A198,A1<183)," Second",IF(AND(A1182,A1<267),"Third",IF(AND(A126 6,A1<351),"Fourth",IF(AND(A1350,A1<435),"Five",IF (AND(A1434,A1<519),"Sixth",IF(AND(A1518,A1<603), "Seventh","Older")))))))

and this formula does not work & and how do I fix it:

=IF(AND(A10,A1<99),"First",IF(AND(A198,A1<183)," Second",IF(AND(A1182,A1<267),"Third",IF(AND(A126 6,A1<351),"Fourth",IF(AND(A1350,A1<435),"Five",IF (AND(A1434,A1<519),"Sixth",IF(AND(A1518,A1<603), "Seventh",IF(AND(A1602,A1<687),"Eight","Older"))) ))))

As soon as I add the eight on, excel has a problem

Regards,