Per FUEL
Conversion Bracket <35% 35.01 to 40.00 40.01 to 44.99 >45%
< 76% 0 10 15 20
>76.01 % < 80.99% 25 30 35 40
>81% < 85.99% 30 35 40 45
> 86% 35 40 45 50
Conversion2 Quality Scores ANSWER
38.46% 89%
43.10% 97%
39.13% 99%
50.00% 92%
51.28% 92%
我想要单元格中的任何IF
或函数,它可以反映上述网格的结果。AND
I9
假设转换介于50.01 to 40.00
和 之间81 to 85.99
,则结果应该是 35。