<div>
<div class="content wysiwyg-content">
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. &nbsp;I was able to reuse an old formula and came up with: 
 
=IF(ISERROR(FIND(&quot;23&quot;,UPPER(W1))),0,K1) 
 
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(&quot;0&quot;,UPPER(W1))),0,K1) it always returns K 
 
But when I replace “0” with 0% 
=IF(ISERROR(FIND(&quot;0%&quot;,UPPER(W1))),0,K1) &nbsp;it always returns the fall back zero. 
 
Has anyone any ideas? 
 
Many thanks!!!!!
</div>
</div>

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:

=IF(ISERROR(FIND("23",UPPER(W1))),0,K1)

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?

Many thanks!!!!!

Problem with iserror find Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.