Forum Discussion

Bailey100's avatar
Bailey100
Brass Contributor
Jun 21, 2019
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?

 

Thanks, Bailey100

excel
Excel Online
Formulas and Functions

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 21, 2019

    Bailey100 

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

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 21, 2019
    SEARCH is case sensitive, is works for me if I use FIND like so:
    =IF(ISERROR(FIND($G2,C$3)),0,$D3)
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 21, 2019

    Bailey100 

     

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

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