• 542K Members
• 5,432 Online
• 645K Conversations
SOLVED

Highlighted
Contributor

# 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?

Thanks, Bailey100

3 Replies
Highlighted
Solution

# Re: Why doesn't my formula work?

In C3 you have a number, it's only formatting on the top. Use

`=IF(TEXT(C3,"mmm")="Jan",D3,0)`
Highlighted

# Re: Why doesn't my formula work?

SEARCH is case sensitive, is works for me if I use FIND like so:
=IF(ISERROR(FIND(\$G2,C\$3)),0,\$D3)
Highlighted

# Re: Why doesn't my formula work?

Given that the expected result is a number, you may also use this Boolean formula:

=(TEXT(\$C3,"mmm")=G\$2)*\$D3