User Profile
catbogle
Copper Contributor
Joined Sep 13, 2022
User Widgets
Recent Discussions
Re: Need help with IF
htrankevin It also looks like the first table has a hidden E column but it does not look like the second table does. Are these the same table or is the second image a different table? Is it really F & G or are the last two columns E & F? (sorry I should have noted here that I put the lines 296 & 297 on line9 and 10 of my sample) Also Keep in mind that lines 296 and 297 ALL Column are the same. So if you are testing B9=B10 (True), F9=4410 (True), G9<>(not equal to) "0000-00" (False) So you should get the . if your formula was correct everywhere else. The same is true for B10 because both B10=B11 and G10<>"0000-00" are false. Hope this helps. Cat974Views0likes0Comments
Recent Blog Articles
No content to show