LinkBack URL
About LinkBacks
I wrote a long IF statement, and I can't figure out why it's returning FALSE.
In the attachments, you can see that the function arguments box shows, Formula result = TRUE, but the other image shows how it looks on the worksheet (FALSE).
Any ideas?
Can't figure out this simple IF statement....
I wrote a long IF statement, and I can't figure out why it's returning FALSE.
In the attachments, you can see that the function arguments box shows, Formula result = TRUE, but the other image shows how it looks on the worksheet (FALSE).
Any ideas?
dbl_dbl,
Can you provide the worksheet(s) used in the formula (few rows of dummy data is all we need), so we can see how the formula works in full?
Ochimus
I don't think I can, this is a very interconnected worksheet and requires multiple references to tables and inputs. I will take a look tonight and see if I can scrub it down enough to make it shareable.
Was hoping someone saw something obvious in the example. I've never had the function box say result = TRUE and then the cell to actually show false. It's not nested within another formula.
Last edited by AliGW; 12-16-2020 at 03:23 AM. Reason: PLEASE don't quote unnecessarily!
there is nothing to actually see in your post - perhaps if you provided the actual formula?Originally Posted by dbl_dbl
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks