I have three columns. Column 1 can be either TRUE or FALSE. If it is TRUE then column 2 cannot also be TRUE. If it is FALSE, then column 2 can be either TRUE or FALSE. If either column 1 or column 2 are TRUE, then column 3 cannot also be TRUE. If neither column 1 nor column 2 are TRUE, then column 3 can be either TRUE or FALSE.
The formula I used for column 2 was an IF(ISNUMBER(SEARCH function. Is there a way to embed an OR in this statement? If not, is there a different formula I can use?
Hello and welcome to the forum.
What are you trying to do? Apply Data Validation?
It will likely be best for you to attach a sample workbook.
Make sure there is just enough data to demonstrate your need.
Make sure your desired results are shown, mock them up manually if necessary.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I agree with 63 that you probably need to use Data Validation here. A cell can contain either an entry OR a formula, so if the cells will contain m,anually entered Y/N, then you cannot also have a formula in them
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks