ST Alpha - "B2: Znu pretty much had it =IF(OR(B1="up006",AND((B1="up260"),(C1>12))),1,0) Got that to work by trial and error" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 157

B2: Znu pretty much had it =IF(OR(B1="up006",AND((B1="up260"),(C1>12))),1,0) Got that to work by trial and error

Posted by JD (aka Jason Dean) Sep 17 '12, 14:01

Znu's version seemed to be short of parenthesis at the AND function

Responses:

my issue was "C1="FT>12"" -- apparently I misspoke. (I'm really not bright today.) -- nm - amanda Sep 17, 14:10 2
- Hmmm. So what exactly are possible values in C1? -- nm - JD Sep 17, 14:18
- ah, I misunderstood the parameter there. -- nm - znufrii Sep 17, 14:12
huh. - znufrii Sep 17, 14:04 1
- In your defense, I used Excel's insert function prompt and came up with the syntax for each logical test and then pasted those into the dialog - JD Sep 17, 14:07

Post a message top

Replies are disabled on threads older than 7 days.