|
Function CalculateValue(ByVal D3 As String, ByVal E3 As String, ByVal F3 As String) As Double On Error Resume Next Dim part1 As Double Dim part2 As Double Dim part3 As Double Dim part4 As Double Dim result As Double part1 = 2 * (Val(Left(D3, InStr(1, D3, "*") - 1)) + Val(Mid(D3, InStr(1, D3, "*") + 1, InStr(InStr(1, D3, "*") + 1, D3, "*") - InStr(1, D3, "*") - 1))) part2 = Val(Mid(D3, WorksheetFunction.Lookup(100, InStr(1, D3, "*"), ROW(1:62)) + 1)) part3 = 0.00785 part4 = Val(Left(E3, Len(E3) * 2 - LenB(E3))) * Val(Left(F3, Len(F3) * 2 - LenB(F3))) result = (part1 * part2 / 1000) * part3 * part4 CalculateValue = WorksheetFunction.Round(result, 3) On Error GoTo 0 End Function |
评分
-
1
查看全部评分
-
|