=IF(AND(A7>=0,A7<=10000),1,IF(AND(A7>=10001,A7<=20000),1.3,IF(AND(A7>=70000,A7<=79000),3.5)))
Obviously using A7 in this example as the cell calculating the total. Now this formula uses the ranges you provided above since I figured that would be easiest to figure out the structure. If the numbers fall in the 20,001-69,999 or 79,001 and above it would return as FALSE.
Last edited by BisyB on February 22, 2016 12:53.