[已解决]我打有一組IF函數，請高手幫忙簡化

wfwangfengwf

=IF(E9="","",IF(AND(D9="Φ25.0"),(135*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ28.0"),(160*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ32.0"),(208*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ32.0"),(208*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ38.0"),(262*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ45.0"),(320*4)+IF(AND(E9="Φ16.0"),(150*4)+F9),IF(AND(D9="Φ25.0"),(135*4)+IF(AND(E9="Φ19.0"),(167*4)+F9),IF(AND(D9="Φ28.0"),(160*4)+IF(AND(E9="Φ19.0"),(167*4)+F9),IF(AND(D9="Φ32.0"),(208*4)+IF(AND(E9="Φ19.0"),(167*4)+F9),IF(AND(D9="Φ38.0"),(262*4)+IF(AND(E9="Φ19.0"),(167*4)+F9),IF(AND(D9="Φ45.0"),(320*4)+IF(AND(E9="Φ19.0"),(167*4)+F9)))))))))))))

最佳答案

月排行榜 / 总排行榜

baksy

2014-8-30 16:13

=LOOKUP(D9,{"Φ25.0","Φ28.0","Φ32.0","Φ38.0","Φ45.0"},{134,160,208,262,320})*4+LOOKUP(E9,{"Φ16.0","Φ19.0"},{150,167})*4+F9

跳转到最佳答案楼层

易安1

{:181:}吐血

zyouong

and在公式中有什么用呢？

baksy

=LOOKUP(D9,{"Φ25.0","Φ28.0","Φ32.0","Φ38.0","Φ45.0"},{134,160,208,262,320})*4+LOOKUP(E9,{"Φ16.0","Φ19.0"},{150,167})*4+F9

wfwangfengwf

樓上的不錯