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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks