Advertisement
veronikaaa86

06. EvenOddSum

Sep 20th, 2022
1,793
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub EvenOddSum()
  2.     Dim n, evenSum, oddSum As Integer
  3.     n = Range("A1")
  4.    
  5.     For i = 1 To n
  6.         Dim currentNum As Integer
  7.         currentNum = Range("B" & i)
  8.        
  9.         If i Mod 2 = 0 Then
  10.             evenSum = evenSum + currentNum
  11.         Else
  12.             oddSum = oddSum + currentNum
  13.         End If
  14.     Next i
  15.  
  16.     If evenSum = oddSum Then
  17.         Debug.Print "Yes Sum = " & evenSum
  18.     Else
  19.         Dim diff As Integer
  20.         diff = Abs(evenSum - oddSum)
  21.         Debug.Print "No Diff = " & diff
  22.     End If
  23.  
  24. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement