? ????? Excel? ISNA ??? ???? #N/A ??? ???? ??? ??? ?????. Excel? ?? ?? ?? ??? ?? #N/A ??? ?????. ISNA ????? ??? ??? ? ??? ??? ?? ?? ??? ????? ? ??????.

• ISNA? ?? ??
• ISNA? IF? ?????
• Vlookup? ?? ISNA? ?????
• SumProduct ? ISNA? ???? #N/A ?? ??

Excel? ISNA ??

ISNA ??? ? ?? ??? #N/A ??? ????, ???? true? ????, ??? ??? false? ?????. Excel 2000 ~ 2021 ? Excel 365? ?????. ??? ?????.

ISNA(value) ?? ??? ? ?? ?? ? ??.

? ??? ??? ?? ISNA ?? :

=ISNA(A2)

a2? #n/a? ?? ??? ??? false? ?? ? ?? true? ?????.

???? ISNA ??

ISNA? ?? ??? ?? ? ? ?? ??????. ?? ??, ISNA? ?? ?? ?? ? ?? ??? ??????.

ISNA(*your_formula*())

? ?? ?? (? A ? D)? ???? List 1? ?? ? ??? ?? ? ??? ?? ??? ?? ? ???. MATCH ??? A3? ? D? ?????.

=MATCH(A3, $D$2:$D$9, 0)

??? ???? ??? ??? ?????. ??? ??? #N/A. Isna? ??? :

=ISNA(MATCH(A3, $D$2:$D$9, 0))

?? ???? ?? (A ?)? D ? (true = ?? ? ??, false = found)??? ?????.

?? : Excel 365 ? 2021 ?????? ?? Xmatch ??? ??? ? ????.

ISNA ?????

ISNA? True/False ? ????? ??? ?? ???? ?? IF? ?? ?????.

IF(ISNA(…), "*text_if_error*", "*text_if_no_error*")

??? ????? ????? "??? ??? ??"? ????? ( #N/A? ???? ??) :

=IF(ISNA(MATCH(A3,$D$2:$D$9,0)), "No failed tests", "Failed")

??? ??? ??? ????.

Vlookup? ?? Isna

IF/ISNA ??? #N/A? ???? ??? ?? ?????. Vlookup? ?? :

IF(ISNA(VLOOKUP(…), "*custom_text*", VLOOKUP(…))

Vlookup? #n/a? ??? ??? ?? ???? ?????. ??? ??? Vlookup? ??? ?????. ??? ??? ?? "??? ??? ??"? ???? ?? :

=IF(ISNA(VLOOKUP(A3, $D$3:$E$9, 2, FALSE)), "No failed tests", VLOOKUP(A3, $D$3:$E$9, 2, FALSE))

Excel 2013? ? ??? ???? ?? IFNA? ?????.

=IFNA(VLOOKUP(A3, $D$3:$E$9, 2, FALSE), "-")

Excel 365 ? 2021 ???? Xlookup? ??? ? ????.

=XLOOKUP(A3, $D$3:$D$9, $E$3:$E$9, "-")

SumProduct ? ISNA? ???? #N/A ?? ??

???? #n/a ??? ?????.

SUMPRODUCT(--ISNA(*range*))

Isna? True/False ??? ????. -- 1? 0s? ?????. SumProduct? ??? ?????. ??? ????? ???? ???? ?? :

=SUMPRODUCT(--ISNA(MATCH(A3:A14, D2:D9, 0)))

? ????? Excel?? ISNA ??? ???? ???? ?? ?????. ???? ??? ??? ??? ? ????.

? ??? ?? ??? ?? ISNA ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!