Forum Discussion
Solved
Why doesn't my formula work?
Hi, see the attached document. I've used a formula: =IF(ISNUMBER(SEARCH("Jan",C3)),D3,0) for cell G3, why is'nt this picking up that there is 'Jan' in C3 and thus producing the value in D3? ...
In C3 you have a number, it's only formatting on the top. Use
=IF(TEXT(C3,"mmm")="Jan",D3,0)
SEARCH is case sensitive, is works for me if I use FIND like so:
=IF(ISERROR(FIND($G2,C$3)),0,$D3)
=IF(ISERROR(FIND($G2,C$3)),0,$D3)