I am trying to write a formula that will use a factor to multiply within the limits below.



to 10 0.0021
10 - 20 0.0017
20 - 30 0.0007
over 30 0.0004

I can complete when only 3 options but am having difficulty adding the fourth variable.

can anyone help?

I'm not sure what you need. Take a look at differential rates

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

In the attached, a lookup table in E2:F5, formulae in column B showing facto:
=INDEX($F$2:$F$5,MATCH(A2,$E$2:$E$5,1))

Attached Files

MSOfficeForums38704.xlsx (9.8 KB, 7 views)