I have a worksheet where a user input a value. There can be 5 different fomulas based on what value the user enters. How do I make a vb script to say

If the value of sheet1 cell A1 is between 1 and 5, do A1-A2.

If the value of sheet1 cell A1 is between 6 and 10, do A1+A2