=IF(H4>1.25%,10%,IF(1%≤H4≤1.25%,9%,IF(0.8%≤H4
问题描述:
=IF(H4>1.25%,10%,IF(1%≤H4≤1.25%,9%,IF(0.8%≤H4
答
“1%≤H4≤1.25%”这种表达方式是不对的,在EXCEL中表达为“AND(1%=1%,9%,IF(H4>=0.8%,8%,6%)))
=IF(H4>1.25%,10%,IF(1%≤H4≤1.25%,9%,IF(0.8%≤H4
“1%≤H4≤1.25%”这种表达方式是不对的,在EXCEL中表达为“AND(1%=1%,9%,IF(H4>=0.8%,8%,6%)))