Is it possible to do something instead of "False" in the formula, for example, an empty cell or the text that I want to introduce?
e.g. in the formula = IF(D =M$2;B2) or others? ;]
greetings ;]
= IF(D2=M$2;B2;"The case, when it is not True")
= IF(D2=M$2;B2;"")
COUNTIF(A2:A50; A2)
IF(COUNTIF(A2:A50; A2);"ok"; "")
IF(ISNA(VLOOKUP(L2;MyTitle;1;0));"";VLOOKUP(L2;MyTitle;1;0))
=IF(ISNA(COUNTIF(A2:A50; B2));""; "ok ")
=IF(ISNA(COUNTIF(A2:A50; B2));""; COUNTIF(A2:A50; B2))
ok this two is working... but what to do if i have: IF(COUNTIF(A2:A50; B2);"ok"; " ")
and in B2 is #N/A then result is #N/A, not " "
=if(isna(countif(A2:A50;B2));"";"OK")
Users browsing this forum: Google [Bot] and 33 guests