IFerror on an IF statement

Copper Contributor

=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?

2 Replies

@weavenation That would be:

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

 

@weavenation 

 

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