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
Try
=IF(ISERROR((LEN(E2)-LEN(SUBSTITUTE(E2,"egbd","")))/4*S2),0,(LEN(E2)-LEN(SUBSTITUTE(E2,"egbd","")))/4*S2)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
thank you
steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks