excel表格怎么实现隔列相乘

1.excel电子表格如何实现多列相乘?

用VBA来做：Sub YunSuan() hang = 1 Application.Calculation = xlCalculationManual For a = 1 To 3 For b = 1 To 3 For c = 1 To 3 For d = 1 To 3 For e = 1 To 3 For f = 1 To 3 For g = 1 To 3 For h = 1 To 3 Cells(hang, 10) = Cells(a, 1) * Cells(b, 2) * Cells(c, 3) * Cells(d, 4) * Cells(e, 5) * Cells(f, 6) * Cells(g, 7) * Cells(h, 8) Cells(1, 9) = hang '在I1单元格显示运算进度 hang = hang + 1 Next Next Next Next Next Next Next Next Application.Calculation = Sub。