is it possible to nest more than 7 functions in an array formula

Hello

i have a formula which looks sumthin lik this:

={sum(if(frequency(if(....,if(....,if(....,if(....,if(.....,abcd),abcd)>0,1))}

but i want to check for one more condition so i want to add one more if in the middle...is it possible??

thanks for any help!

it is possible but formulas get a bit mental. I had to do it on one if mine here is the formula I had in the end


=IF(OR(INFO!A26=275,INFO!A26=355),IF(OR(INFO!C13=5,INFO!C13=6,INFO!C13=7,INFO!C13=8,INFO!C13=9,INFO!C13=10,INFO!C13=12,INFO!C13=15,INFO!C13=18,INFO!C13=20,INFO!C13=25),IF(OR(INFO!B18=16,INFO!B18=20,INFO!B18=24,INFO!B18=30),IF((IF(INFO!A26=275,IF(INFO!B18=16,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE)),IF(INFO!B18=20,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE)),IF(INFO!B18=24,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE)),IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE))))), IF(INFO!B18=16,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,3,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M16Bolts,3,FALSE)),IF(INFO!B18=20,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,3,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M20Bolts,3,FALSE)),IF(INFO!B18=24,IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,3,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M24Bolts,3,FALSE)),IF(VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,3,FALSE)>=VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE),VLOOKUP("Max Single",'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,2,FALSE),VLOOKUP(INFO!C13,'CHS Bracing Calculation Sheet (with Tension Check).xlsx'!M30Bolts,3,FALSE))))))*INFO!A18)>=INFO!B4,"OK","FAIL"),"N/A"),"N/A"),"N/A")


there probably is a better way but I couldn't think it out as you can see it gets messy

thanks everyone...i found out that i can use the "*" operator to check multiple conditions...works great!