#value

[stevekirk]

Hi,

this is the formular that looks in cell e2 for the word "egbd" if iot is not there is gives me the result #value

=(LEN(E2)-LEN(SUBSTITUTE(E2,"egbd","")))/4*S2

i need it to be 0 as the result is part of some maths

thanks
steve

[VBA Noob]

Try

=IF(ISERROR((LEN(E2)-LEN(SUBSTITUTE(E2,"egbd","")))/4*S2),0,(LEN(E2)-LEN(SUBSTITUTE(E2,"egbd","")))/4*S2)

VBA Noob

[stevekirk]

thank you

steve