Forum Discussion

Copper Contributor

Dec 23, 2021

Solved

IF formula returning only false condition value

Hi, I am trying to figure out why this formula is not working as intended. =IF(A2="Note",(RIGHT(A2,(LEN(A2)-42))),(RIGHT(A2,(LEN(A2)-49)))) If the cell contains the word "Note" then I want it t...

excel

Detlef_Lewin
Dec 23, 2021
A2="Note" checks if cell A2 is equal to "Note". If you want to check if "Note" is anywhere in cell A2 then use ISNUMBER(SEARCH("Note",A2)).

Detlef_Lewin

Silver Contributor

Dec 23, 2021

A2="Note" checks if cell A2 is equal to "Note". If you want to check if "Note" is anywhere in cell A2 then use ISNUMBER(SEARCH("Note",A2)).

Nohemi5280

Copper Contributor

Dec 27, 2021

Detlef_Lewin

Thanks that did the trick in recognizing both conditions. My final formula is =IF(ISNUMBER(SEARCH("Note",A4)),(RIGHT(A4,(LEN(A4)-42))),IF(ISNUMBER(SEARCH("Deed",A4)), (RIGHT(A4,(LEN(A4)-47)))))

SergeiBaklan
Diamond Contributor
Dec 27, 2021
Nohemi5280

As variant

=RIGHT( A4, LEN(A4) - 47 + 5*ISNUMBER( SEARCH( "Note", A4 )) )