Forum Discussion

Nohemi5280's avatar
Nohemi5280
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's avatar
    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)).
Nohemi5280's avatar
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's avatar
SergeiBaklan
Diamond Contributor
Dec 27, 2021

Nohemi5280 

As variant

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

Resources