|
本帖最后由 idnoidno 于 2017-5-28 21:50 编辑
1 | 2 | 3 | 4 | 5 |
| | |
| |
| |
| | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | 2 | 1 | 2 | 1 | 10 | 76 | 0.083333 | |
| |
| | 912 | 1 | 工作表如上,代碼如下,請問路過的高手大哥,可以指導一下嗎其中,
If a3>a1, a3*a1;
If a3<a2,a3*a2*2 ..............
76=a3*a1+b3*b1*2+c3*c1*2+d3*d1*2+e3*e1
0.083333=76/912
- Option Explicit
- Sub taa()
- Dim mrr
- Dim i As Integer, j As Integer
- Dim rg As Object
- Dim tempsum
- With Worksheets("工作表1")
- Range("f:f").ClearContents
- Set rg = Range("a1:f" & Cells(Rows.Count, "A").End(xlUp).Row)
- mrr = rg
- For i = 3 To UBound(mrr)
- tempsum = 0
- For j = 1 To UBound(mrr, 2)
- If mrr(i, j) > mrr(1, j) Then
- mrr(i, UBound(mrr, 2)) = mrr(i, UBound(mrr, 2)) + mrr(i, j) * mrr(1, j)
- Else
- mrr(i, UBound(mrr, 2)) = mrr(i, UBound(mrr, 2)) + mrr(i, j) * mrr(1, j) * 2
- End If
- Next j
- tempsum = tempsum + mrr(i, UBound(mrr, 2))
- Next i
- rg = mrr
- Set rg = Nothing
- End With
- Dim mrg As Object
- Dim brr As Variant
- With Worksheets("工作表1")
- Set mrg = Range("f1:g" & Cells(Rows.Count, "f").End(xlUp).Row + 1)
- brr = mrg
- For i = 3 To UBound(brr) - 1
- brr(UBound(brr), 1) = brr(UBound(brr), 1) + brr(i, 1)
- Next i
- mrg = brr
- Set mrg = Nothing
- End With
- Dim nrg As Object
- Dim crr As Variant
- With Worksheets("工作表1")
- Set nrg = Range("f1:g" & Cells(Rows.Count, "f").End(xlUp).Row)
- crr = nrg
- For i = 3 To UBound(crr)
- crr(i, 2) = crr(i, 1) / crr(UBound(crr), 1)
- Next i
- nrg = crr
- Set nrg = Nothing
- End With
- End Sub
复制代码
|
|