Have too many ifs for one formula

[BrianKebic]

Have too many ifs in my formula. If I trying using IFS the formula doesn't work. Tried usings IFS, and several other combinations but to no avail. Maybe I'm trying to do too much for cell?

=IF(F8="","",AND(D8<10,M8<=M6+2),M6,AND(D8<10,M8>M6+2),M6+2,AND(D8>9<20,M8<=7),M6,AND(D8>9<20,M8>7),7,AND(D8>19<30,M8<8),M8,AND(D8>19<30,M8>8),8,AND(D8>29<40,M8<=9),M8,AND(D8>29<40,M8>9,9)

So basically in cell M10
if D8<10 & M8<=M6+2 are true then M6
if D8<10 & M8>M6+2 are true then M6+2
if D8>9<20 & M8<=7 are true then M6
if D8>9<20 & M8>7 are true then 7
if D8>19<30 & M8<=8 are true then M6
if D8>19<30 & M8>8 are true then 8
if D8>29<40 & M8<=9 are true then M6
if D8>29<40 & M8>9 are true then 9

Any thoughts?

 

[James006]

Hello,

Take a look at following :

https://ccm.net/faq/26886-nesting-more-than-7-if-statements-in-an-excel-function

HTH

 

[BrianKebic]

HTH - tks for the response. Still having problems but I suspect its the "AND" function that I'm not using right. Back to the basics to see if I can put this together somehow.

 

[Giordano Bruno]

Hi Brian. Your formula is all wrong. The formula should be written as =IF(F8="","",if(AND(D8<10,M8<=M6+2),M6,If(… The syntax is If(a then b if not then if(c then d if not then d)). This won't fix your formula as you can only nest 7 ifs. The solution is to break your formula into two parts and combine the results with a "+" and with each part having less than 7 nested ifs.