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,
|