Advertisement
veronikaaa86

11. Coins

Sep 20th, 2022
1,839
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub Coins()
  2.     Dim change, coinsChange As Double
  3.     change = 0.56
  4.     coinsChange = change * 100
  5.    
  6.     Dim count As Integer
  7.    
  8.     Do While coinsChange > 0
  9.         If coinsChange >= 200 Then
  10.             coinsChange = coinsChange - 200
  11.         ElseIf coinsChange >= 100 Then
  12.             coinsChange = coinsChange - 100
  13.         ElseIf coinsChange >= 50 Then
  14.             coinsChange = coinsChange - 50
  15.         ElseIf coinsChange >= 20 Then
  16.             coinsChange = coinsChange - 20
  17.         ElseIf coinsChange >= 10 Then
  18.             coinsChange = coinsChange - 10
  19.         ElseIf coinsChange >= 5 Then
  20.             coinsChange = coinsChange - 5
  21.         ElseIf coinsChange >= 2 Then
  22.             coinsChange = coinsChange - 2
  23.         ElseIf coinsChange >= 1 Then
  24.             coinsChange = coinsChange - 1
  25.         Else
  26.             Exit Do
  27.         End If
  28.        
  29.         count = count + 1
  30.        
  31.     Loop
  32.    
  33.     Debug.Print count
  34.    
  35. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement