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 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 GuidelinesJobs |
Need help with Boolean logic on a data list
|
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".