張芝瑜EXCEL名稱方塊,AND,OR,COUNT,COUNTIF,INDIRECT間接定址
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 29 FALSE FALSE FALSE FALSE =AND(ISNUMBER(U504),ISNUMBER(U1007)) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! FALSE TRUE FALSE FALSE =AND(ISNUMBER(U505),ISNUMBER(U1008)) 0 這個名稱定址的資訊 6 3 6 4 0 32 118 0 0 3 3 買權賣權 範圍 S1:Y505 3 TRUE 0 501 FALSE 169 INDRC間接定址找Indirect Addressing 到X508儲存格找位址