In other words, here is the following:

IF the Sales total is LESS THAN 100,000...then multiple Sales by 5%

IF the Sales total is BETWEEN 101,000 and 500,000,..then multiple Sales by 6%

IF the Sales total is GREATER THAN 101,000 and 500,000,..then multiple Sales by 7%

Help is much appreciated !