Need help with Boolean logic on a data list
Need help with Boolean logic on a data list
(OP)
I am not normally this troubled, but this has been baffling me for 3 days.
See attached xlsx file.
See attached xlsx file.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
Need help with Boolean logic on a data list
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Need help with Boolean logic on a data list
6) "CONT" is manually input into col C only if suffix of col B is "A". I don't want "CONT" automatically generated in col C, it has to be input in only one instance on the entire worksheet.
RE: Need help with Boolean logic on a data list
"and green D row shall be inverse of whateved non-zero sequence 1 to 2 or anything up to 1 to 5"
Also you seem to have your rows and columns reversed in some of the rules.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Need help with Boolean logic on a data list
RE: Need help with Boolean logic on a data list
The numbers in col D and col E are for indexing, looking up data elsewhere.
RE: Need help with Boolean logic on a data list
Don't spend any more time on this, I started a fresh approach and am making some headway. It may be very inelegant but it seems to be the right direction.
Just don't waste any more time on this - until I notify otherwise.
RE: Need help with Boolean logic on a data list
RE: Need help with Boolean logic on a data list
D28: =IF(col_c<>"",1,IF(D27<>0,IF(AND("A"<=RIGHT(col_b,1),RIGHT(col_b,1)<"F"),CODE(RIGHT(col_b,1))-CODE("A")+1,0),0))
E28: =IF(col_c<>"",MAX(col_d),IF(E27>0,E27-1,0))
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Need help with Boolean logic on a data list
My markup: http://files.engineering.com/getfile.aspx?folder=e...
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Need help with Boolean logic on a data list
Wow, I thought I knew the basics but evidently I have much to learn. That was much more efficient...and I just modified it slightly.
See attached, for the record.
RE: Need help with Boolean logic on a data list
Thanks!!!
RE: Need help with Boolean logic on a data list
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Need help with Boolean logic on a data list
At first when I tried to use the info you gave me from your first post 1:48, nothing worked, almost like the cell formula was text instead. Then I tweaked a couple of things and it worked, altho a very slightly concept from what you gave me.
I wasn't familiar with that CODE function and the syntaxes of many things in those formulas were new to me.
Then later when you sent that 1:53 update, that worked too, "right out of the box".