Guest User

Untitled

a guest
Oct 15th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Sub func()
  2. N = Cells(2, 1)
  3. a = Cells(2, 2)
  4.  
  5. Sum1 = 0
  6. fa = 1
  7. For i = 0 To N
  8. fa = fa * (a + i)
  9. Sum1 = Sum1 + 1 / fa
  10. Next i
  11. Cells(4, 1) = Sum1
  12.  
  13. Sum2 = 1 / a
  14. For i = 1 To N
  15. Sum2 = Sum2 + 1 / a ^ (2 * i)
  16. Next i
  17. Cells(6, 1) = Sum2
  18.  
  19. Sum3 = a
  20. For i = 1 To N
  21. Sum3 = Sum3 * (a - i * N)
  22. Next i
  23. Cells(8, 1) = Sum3
  24. End Sub
Add Comment
Please, Sign In to add comment