Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Sub var1()
  2. Dim fc, tc, pc, bc As Range
  3. Set fc = Range("B1:B11")
  4.  
  5. Dim f, t, p, b As Double
  6. Dim d, c, y As Double
  7.  
  8. Dim i As Integer
  9. Dim x() As Variant
  10.  
  11. d = 1.89
  12. c = 0.4
  13. y = 1.6
  14.  
  15. x = Array(0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4, 4.5, 5)
  16.  
  17. For i = 0 To 9
  18.  
  19. If x(i) > b Then
  20. t = (Cos(x(i)) ^ 2 + Sin(b))
  21. ElseIf x(i) <= b Then
  22. t = Atn(x(i)) + b
  23. End If
  24.  
  25. f = t ^ 2 + Sin(x(i)) ^ 2
  26.  
  27. p = f + Sqr(18.45) * Sin(c) + t
  28.  
  29. b = (Log(x(i)) ^ 2 + d * y) / (Sin(c) + Cos(d))
  30.  
  31. MsgBox "x(" & i & ")=" & x(i) & Chr(10) & Chr(10) & "t = " & t & Chr(10) & "p = " & p & Chr(10) & "f = " & f & Chr(10) & "b = " & b
  32. Next i
  33. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement