Home

If Formula is not working

Amin64
Occasional Visitor

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

2 Replies
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!

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")

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies