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