ST Alpha - "=IF(OR(B1=UP006, AND(B1=UP260, C>12)),1, 0) -- nm" (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: 154

In response to "I'm getting sick so I'm stupid right now. help with excel, please?" by amanda

=IF(OR(B1=UP006, AND(B1=UP260, C>12)),1, 0) -- nm

Posted by znufrii Sep 17 '12, 13:05

(No message)

Responses:

After trial and error, I found that =IF(OR(B1="up006",AND((B1="up260"),(C1>12))), 1,0) works - JD Sep 17, 13:54
wait, this doesn't work. it can't be both. -- nm - amanda Sep 17, 13:09 3
- I've always found nested functions can get flaky. - spamlet Sep 17, 13:13 1
  - I did, I always hose myself with no quotes, so I watch for that. I might just call it a day and go home stupid. - amanda Sep 17, 13:17
- can't be both what? -- nm - znufrii Sep 17, 13:12
Its amazing how well some of you know Excel -- nm - Jovian Sep 17, 13:07
I make out with you. (but not really because I'm getting sick.) thanks, znu. -- nm - amanda Sep 17, 13:05 1
- no prob - znufrii Sep 17, 13:06

Post a message top

Replies are disabled on threads older than 7 days.