要如何D5、E5、F5、G5、H5也有D4「IF」函數的能力?
(而不用ㄧ個ㄧ個數函慢慢更改)
註:=IF(D3>=15,IF(D4>0,"A","B1"),IF(D3>=10,IF(D4>0,"B2","C"),IF(D3>0,IF(D4>0,"C1","C2"),"D")))
Excel「IF」操作問題?
回答 (2)
2017-06-19 9:19 am
.
版大公式應可簡為:
=IF(D3>0,LOOKUP(D3,{0,10,15},IF(D4>0,{"C1","B2","A"},{"C2","C","B1"})),"D")
點選D5，以滑鼠指標按住儲存格右下角的十字，然後向右拉到H5即可複製公式
版大公式應可簡為:
=IF(D3>0,LOOKUP(D3,{0,10,15},IF(D4>0,{"C1","B2","A"},{"C2","C","B1"})),"D")
點選D5，以滑鼠指標按住儲存格右下角的十字，然後向右拉到H5即可複製公式
2017-06-26 3:29 pm
我記得 可以找youtube上面 有些老師都有丟他們教學在上面!!!!
收錄日期: 2021-04-25 00:28:15
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170618213026AA5zVug