veronikaaa86

05. VAT

Sep 7th, 2022
1,158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub VATProblem()
  2.     Dim quantity, amount, price, VAT, totalPrice As Double
  3.     quantity = Range("B2")
  4.     amount = Range("D2")
  5.     price = quantity * amount
  6.     VAT = price * 0.2
  7.     totalPrice = price + VAT
  8.    
  9.     Debug.Print price
  10.     Debug.Print VAT
  11.     Debug.Print totalPrice
  12.    
  13.     Range("E2") = price
  14.     Range("F2") = VAT
  15.     Range("G2") = totalPrice
  16.    
  17. End Sub
Advertisement
Add Comment
Please, Sign In to add comment