=if(and(B3=1,B7=1),1,if(and(B3=2,B7=1),1,if(and(B3=3,B7=1),1,if(and(B3=4,B7=1),1,if(and(B3=5,B7=1),1,if(and(B3=6,B7=1),1,if(and(B3=7,B7=1),1,if(and(B3=8,B7=1),1,if(and(B3=9,B7=1),1,if(and(B3=10,B7=1),1,if(and(B3=2,B7=2),2,if(and(B3=3,B7=2),2,if(and(B3=4,B7=2),2,if(and(B3=5,B7=2),2,if(and(B3=6,B7=2),2,if(and(B3=7,B7=2),2,if(and(B3=8,B7=2),2,if(and(B3=9,B7=2),2,if(and(B3=10,B7=2),2,if(and(B3=3,B7=3),3,if(and(B3=1,B7=3),1,if(and(B3=1,B7=2),1,if(and(B3=4,B7=3),3,if(and(B3=5,B7=3),3,if(and(B3=6,B7=3),3,if(and(B3=7,B7=3),3,if(and(B3=8,B7=3),3,if(and(B3=9,B7=3),3,if(and(B3=10,B7=3),3,if(and(B3=1,B7=4),1,if(and(B3=2,B7=4),2,if(and(B3=3,B7=4),3,if(and(B3=4,B7=4),4,if(and(B3=5,B7=4),4,if(and(B3=6,B7=4),4,if(and(B3=7,B7=4),4,if(and(B3=8,B7=4),4,if(and(B3=9,B7=4),4,if(and(B3=10,B7=4),4,if(and(B3=1,B7=5),1,if(and(B3=2,B7=5),2,if(and(B3=3,B7=5),3,if(and(B3=4,B7=5),4,if(and(B3=5,B7=5),5,if(and(B3=6,B7=5),5,if(and(B3=7,B7=5),5,if(and(B3=8,B7=5),5,if(and(B3=9,B7=5),5,if(and(B3=10,B7=5),5,if(and(B3=1,B7=6),1,if(and(B3=2,B7=6),2,if(and(B3=3,B7=6),3,if(and(B3=4,B7=6),4,if(and(B3=5,B7=6),5,if(and(B3=6,B7=6),6,if(and(B3=7,B7=6),6,if(and(B3=8,B7=6),6,if(and(B3=9,B7=6),6,if(and(B3=10,B7=6),6,if(and(B3=1,B7=7),1,if(and(B3=2,B7=7),2,if(and(B3=3,B7=7),3,if(and(B3=4,B7=7),4,if(and(B3=5,B7=7),5,if(and(B3=6,B7=7),6,if(and(B3=7,B7=7),7,if(and(B3=8,B7=7),7,if(and(B3=9,B7=7),7,if(and(B3=10,B7=7),7,if(and(B3=1,B7=8),1,if(and(B3=2,B7=8),2,if(and(B3=3,B7=8),3,if(and(B3=4,B7=8),4,if(and(B3=5,B7=8),5,if(and(B3=6,B7=8),6,if(and(B3=7,B7=8),7,if(and(B3=8,B7=8),8,if(and(B3=9,B7=8),8,if(and(B3=10,B7=8),8,if(and(B3=1,B7=9),1,if(and(B3=2,B7=9),2,if(and(B3=3,B7=9),3,if(and(B3=4,B7=9),4,if(and(B3=5,B7=9),5,if(and(B3=6,B7=9),6,if(and(B3=7,B7=9),7,if(and(B3=8,B7=9),8,if(and(B3=9,B7=9),9,if(and(B3=10,B7=9),9,if(and(B3=1,B7=10),1,if(and(B3=2,B7=10),2,if(and(B3=3,B7=10),3,if(and(B3=4,B7=10),4,if(and(B3=5,B7=10),5,if(and(B3=6,B7=10),6,if(and(B3=7,B7=10),7,if(and(B3=8,B7=10),8,if(and(B3=9,B7=10),9,if(and(B3=10,B7=10),10,"")))))))))))))))))))))))))))))


이런 함수인데 줄이는 방법 없을까?

a=2 b=1 c=1 일때 d=1 이라고 가정하고

a=2 b=1 c=1, d=1

a=4 b=2 c=2, d=2

a=4 b=1 c=1, d=1

a=6 b=4 c=3, d=3

a=6 b=1 c=3, d=1

a=2 b=4 c=7, d=1

a=4 b=4 c=4, d=2

a=8 b=7 c=3, d=3

이런식으로 나왔으면 하는데 위에 처럼 쭉 나열하니까 너무 길어서 엑셀에서 인식도 안되고 손도 아프고.....

엑린이는 웁니다 ㅜㅜ

그나마 간편하게 하는 함수 좀 알려주라