If i want to have multiple IF statements, how would i write the formula?
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 !
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 !