Hi Everyone,
Im hoping you can help me with this, its probably really simple to fix but I just cant see the wood for the trees.
Heres the formula.....
=IF(L29="dog",(LEFT(K29,FIND(" ",K29)-1)),((LEFT(K29,FIND(" ",K29)-1))*Q29))
For some reason, the section in bold is returning the value with quotation marks stopping me from onward processing. I don't have this issue on the back end of the formula though.
Thanks for your help
Kind regards
Alex
Bookmarks