发布网友 发布时间:2024-01-08 05:56
共3个回答
热心网友 时间:2024-08-11 05:56
“H11>=85%<95%”写法错。EXCEL表达为:AND(H11>=85%,H11<95%)。热心网友 时间:2024-08-11 05:53
=IF(H11<85%,"■",IF(H11<95%,"▲",IF(H11<105%,"○","□")))热心网友 时间:2024-08-11 05:53
=IF(H11<85%,"■",IF(H11<95%,"▲",IF(H11<=105%,"○","□")))