Min() 如何不計小於0的欄位

E226:I226 - -100, 0, 10, 20, 30
MIN(IF(E226:I226)>0,(E226:I226),"")
結果是 #value
請問要如何修改?

ChatGPT 給了答案
MINIFS(E226:I226, E226:I226, “>0”)

You can change the formula to as below:
MINIFS(E226:I226, E226:I226, “>0”)

1 Like