[EXCEL] 查表函數運用(IF、ISNA、VLOOKUP、TEXT). D2函數:=TEXT(A2,"000")&TEXT(B2,"00"). F2函數:=IF(ISNA(VLOOKUP($D$2,DATA,2,0)),0 ...
確定! 回上一頁