Forum Discussion

Amin64's avatar
Amin64
Copper Contributor
Jan 18, 2019

If Formula is not working

Hi All,

 

This is my first time on this community. Hoping will get some good diagnosis and solution for my issue.

 

I have an IF condition that is working for one data set but not for another similar dataset. I am not able to figure our why? Attached are the print screens for review.

 

Can someone please help?

 

Thanks

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 18, 2019

    It's hard to say without the file. As a variant that could be extra space or invisible character in "Commitment Fee" text in your table. To check in any empty cell =(G2="Commitment Fee")

  • longjrjoseph's avatar
    longjrjoseph
    Copper Contributor
    Jan 18, 2019
    It looks like you might be off by a row on the 2 examples that aren't working. You could use a vlookup instead of an if statement so that wouldn't matter so much as long as you grabbed the whole section you are trying to reference. This is my first time on this too!

Resources