Tony davis
New Member
I am trying to make a formula that will check a number in a cell to see which range it falls in(ex 1-100, 101-200, etc) and then multiply it by a value corresponding to the range it is in. For example, if the number is 55, then it would look at the range and multiply it by .98 for any number between 1-100.