close
標題:
Excel equation type ABC
發問:
How to write this formula to define a number in a cell to type A or B or C Excel If A2<=10, type C. A2>=11 and <=25, type B. A2>=26, type A Thanks a lot
最佳解答:
其他解答:
Excel equation type ABC
發問:
How to write this formula to define a number in a cell to type A or B or C Excel If A2<=10, type C. A2>=11 and <=25, type B. A2>=26, type A Thanks a lot
最佳解答:
此文章來自奇摩知識+如有不便請留言告知
復制以下公式到你需要的儲存格便可︰ =IF(A2<=10,"C",IF(AND(A2>=11,A2<=25),"B",IF(A2>=26,"A","Out of Range"))) 希望是你所要的! 圖片參考:http://hk.geocities.com/tult010/knowledge/Alex.gif其他解答:
文章標籤
全站熱搜
留言列表