IF() with #VALUE
ups
=IF(ISERROR(SEARCH(A1,B2)),"B","A")
"excelent" skrev:
=IF(ISERROR(SEARCH(A1,B2));"B";"A")
"avgrin" skrev:
IF(search(A1, B2)0,A,B)
I'm searching for a string in A1 in the cell B2, if B2 contains A1, search()
returns starting position of A1, and operation A is performed. However, when
it is not there, #VALUE is returned. How do I get operation B?
Thank you
|