此EXCEL求解,在不同的C D E F G的欄位中,所得到的4列答案都算錯,不知道該如何更改公式?
回答 (2)
2017-06-16 5:38 pm
2017-06-16 11:41 am
=INT(SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(0&F1:F3,"天"," "),"H","/8")*{1;1;-1}))&"天"陳列公式輸入完後按住CTRL+SHIFT+ENTER鍵
收錄日期: 2021-04-28 17:29:11
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170615135133AAywJtA