求救excel公式高手

Question

請問用EXCEL設立條件若A1=100%就以○符號表示,若A1>=90%就以△符號表示,若A1<90%就以■符號表示,請幫忙解答,感恩不盡!!謝謝^^

Answer 1

最佳解答

=IF(A1=1,"○",IF(A1<0.9,"■","△"))

或

=LOOKUP(A1,{0,0.9,1},{"■","△","○"})

2015-01-21 09:54:47 補充：

=IF(A1=1,"○",IF(A1<0.9,"■","△"))

或

=LOOKUP(A1,{0,0.9,1},{"■","△","○"})

請參考

Answer 2

謝謝您,你真厲害!!