Problem with iserror find Formula
Posted on 2014-07-16
I am trying to get excel to do the following.
If the contents of one cell W contains 23% return the contents of another cell K if not return 0. I was able to reuse an old formula and came up with:
This works even if the number is 23 or 23 %.
But when I try adapting the formula as below to search for 0
=IF(ISERROR(FIND("0",UPPER(W1))),0,K1) it always returns K
But when I replace “0” with 0%
=IF(ISERROR(FIND("0%",UPPER(W1))),0,K1) it always returns the fall back zero.
Has anyone any ideas?