#value!

Hi

this code will turn up the value b
but if not b it turns up #VALUE!

i would like it to turn up just b or blank

what do i need to change ?

thanks

the code is

=IF(SEARCH("water",$C9)>0,"b","")

Here, try this:

=IF(ISERROR(SEARCH("water",$C9)),"","b")

Originally Posted by zbor

Here, try this:

=IF(ISERROR(SEARCH("water",$C9)),"","b")

yes

that is it

thank you