I currently have the following formula in a cell:
IF(AND(J40=12,J41="YES"),"Multiple",IF(J39="","",I F(AND(B48="NO",J40=6),SUM(B39,B41,B43)*3,IF(B48="Y ES",SUM(B49:B52,B41,B43,B43,B45),IF(AND(B46="YES", D54="YES"),(((+B39+B41+B43)*2)+B45),IF(B46="YES",( ((+B39+B41+B43)*4)+B45),IF(D54="YES",(((+B39+B41+B 43)*2)+B45),(((+B39+B41+B43)*4)+B45+B45))))))))

I want to add another condition: IF(AND(J40=4,B48="YES"),(B50+B51)*2)

Any ideas on how to get past the limitation of 7? Maybe a better, more
condensed, way to write the formula?