I need help with this IF statement for cell L12.
I have it correct until i add in the tiers below for what would be imput into I3
IF(I3<8500.01, IF(L3<0.81, 0.22, IF(L3<0.86, 0.24, IF(L3<0.91, 0.26, IF(L3<0.96, 0.28, IF(L3<1.01, 0.3, IF(L3<1.06, 0.32, IF(L3<1.11, 0.34, IF(L3<1.21, 0.36, 0.38)))))))), IF(I3<1750.01, IF(L3<0.81, 0.2, IF(L3<0.86, 0.22, IF(L3<0.91, 0.24, IF(L3<0.96, 0.26, IF(L3<1.01, 0.28, IF(L3<1.06, 0.3, IF(L3<1.11, 0.32, IF(L3<1.21, 0.34, 0.36))))))))), IF(I3<2850.01, IF(L3<0.81, 0.16, IF(L3<0.86, 0.18, IF(L3<0.91, 0.2, IF(L3<0.96, 0.22, IF(L3<1.01, 0.24, IF(L3<1.06, 0.26, IF(L3<1.11, 0.28, IF(L3<1.21, 0.3, 0.32))))))))), IF(L3<0.81, 0.14, IF(L3<0.86, 0.16, IF(L3<0.91, 0.18, IF(L3<0.96, 0.2, IF(L3<1.01, 0.22, IF(L3<1.06, 0.24, IF(L3<1.11, 0.26, IF(L3<1.21, 0.28, 0.3)))))))))
This is added on sheet 2, but i dont want to keep this formula there, i want to remove it from the workbook.
Tier 1 Tier 2 Tier 3 Tier 4
>8500 8500.01-17500 1750.01-28500 28500.01>
0% 80% 22% 20% 16% 14%
81% 85% 24% 22% 18% 16%
86% 90% 26% 24% 20% 18%
91% 95% 28% 26% 22% 20%
96% 100% 30% 28% 24% 22%
101% 105% 32% 30% 26% 24%
106% 110% 34% 32% 28% 26%
111% 120% 36% 34% 30% 28%
121% 38% 36% 32% 30%
Bookmarks