我有一個檢查字串的代碼，但我無法將其放入陣列公式中，如果有人可以提供幫助，我將不勝感激！我的作業表副本在哪里
https://docs.google.com/spreadsheets/d/10mkrxCLGkOcKrm481jnsMdQTlf_kgoXUF3eWLKJnKS0/edit?usp=sharing
=IF(AND(
MID(A5,8,1)=MID(A5,5,1),MID(A5,2,1)=MID(A5,5,1)),"1 - monoton",
IF(AND(MID(A5,8,1) <> MID(A5,5,1), MID(A5,2,1) <> MID(A5,5,1), MID(A5,2,1) <> MID(A5,8,1)), "3 - rainbow",
"2 - two tone"))
uj5u.com熱心網友回復：
采用：
=ARRAYFORMULA(IF((
MID(A5:A,8,1)=MID(A5:A,5,1))*(MID(A5:A,2,1)=MID(A5:A,5,1)),"1 - monoton",
IF((MID(A5:A,8,1) <> MID(A5:A,5,1))*(MID(A5:A,2,1) <> MID(A5:A,5,1))*(MID(A5:A,2,1) <> MID(A5:A,8,1)), "3 - rainbow",
"2 - two tone")))
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/471629.html