SOLVED

Why doesn't my formula work?

Brass Contributor

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
best response confirmed by Bailey100 (Brass Contributor)
Solution

@Bailey100 

 

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)

@Bailey100 

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

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

1 best response

Accepted Solutions
best response confirmed by Bailey100 (Brass Contributor)
Solution

@Bailey100 

 

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

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

View solution in original post