I have a column of values in currency form. I need a formula that will look each value up in a "range of ranges" and apply the corresponding percentage to the original value, i.e. if the value is between $0 and $5000, multiply by 10%; if the value is between $5001 and 10000, multiply by 13%; if the value is between $10001 and $20000, multiply by 15%, and so on.
Is this possible? Anybody have any ideas?
Is this possible? Anybody have any ideas?