这个用公式是不能实现的,需要用到VBA,用多层循环嵌套。
这种问题是比较典型的初级循环练习,如下(以相加结果是10为例):
Sub button_click()
Dim i, j, k, l As Integer
l = 1
For i = 0 To 9
For j = i To 9
For k = j To 9
‘以相加结果是10为例,如果是别的值可修改下面一行
If i + j + k = 10 Then
Cells(l, 2) = i & "," & j & "," & k
l = l + 1
End If
Next
Next
Next
End Sub