User Profile
psaavedra3
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Why is my formula not working correctly
I have used a formula to find items over $1,000 and not in a session and while it finds some items correctly its still finding items that are on the sessions and still displaying as not on a session. In col E if its Yes it shouldn't have anything in col F. If you scroll down you will see a few items that have a YES in col E and "Above $1,000...." in col F. Why is that ? What is wrong with my formula. Here is the formula is col F: =IF(D48<=1000,"",IF(AND(D48>1000,NOT(ISNA(MATCH(C48,Sessions!$C$3:$C$1000,0)))),"","Above $1,000 and not in a Session"))
