根据两个单元格之间的百分比给出规则?

Question

我需要 R5 告诉我 L5 是否大于 F5 一定百分比。例如：

If L5 is greater than F5 by 9.99% or less then I need R5 to = Full
If L5 is greater than F5 by 10% -  19.99% then I need R5 to = Half

最后

If L5 is greater than F5 by 20% or greater then I need R5 to = NONE

Answer 1

假设 99 不算作大于 100 小于 10% 的 IF 应该有效：

=IF(AND(L5>F5,L5<=1.0999*F5),"Full",IF(AND(L5>F5,L5<=1.1999*F5),"Half",IF(L5>=1.2*F5,"NONE"))) 

没有规定L5小于F5的位置。