IFerror on an IF statement

Question

=IF(ISNUMBER(SEARCH("yes",J9)),V9/W9,"Not needed")

Hi all, the above IF statement is spitting out a DIV/0 error, any ideas on how i can integrate the IFERROR formula into this statement while also retaining the original IF statement?

riny_van_eekelen · Answer

weavenation&nbsp;That would be:=IFERROR(IF(ISNUMBER(SEARCH("yes",J9)),V9/W9,"Not needed"),"")&nbsp;

joeuser2004 · Answer

weavenation&nbsp;&nbsp;=IFERROR(ISNUMBER(SEARCH("yes",J9))*V9/W9,"Not needed")

Forum Discussion

IFerror on an IF statement