Advertisement
darkor

economic_lab_vba_excel

Dec 12th, 2020
1,569
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub qq()
  2.  
  3. Dim x, z, dobutok, summa As Double
  4. Dim m, n, k As Integer
  5.  
  6. x = 3.17
  7. m = 10
  8.  
  9. dobutok = 1
  10. n = 4
  11.  
  12. summa = 0
  13. k = 1
  14.  
  15. For n = 4 To 12
  16.     Fact = 1
  17.     For i = 1 To n + 1
  18.         Fact = Fact * i
  19.     Next i
  20.    
  21.     dobutok = dobutok * Cos(x) * Fact
  22. Next n
  23.  
  24. For k = 1 To m
  25.     Fact2 = 1
  26.     For j = 1 To k
  27.         Fact2 = Fact2 * j
  28.     Next j
  29.    
  30.     summa = summa + Sqr(Fact2 * Abs(Sin(x)))
  31. Next k
  32.  
  33. z = dobutok + 1 / summa
  34.  
  35. MsgBox z
  36.  
  37. End Sub
  38.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement