ST Alpha - "what's the easiest way in excel to do: if [number] is in [range],1; if not 2? I always forget. thanks. -- 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: 157

what's the easiest way in excel to do: if [number] is in [range],1; if not 2? I always forget. thanks. -- nm

Posted by amanda Sep 11 '12, 12:26

(No message)

Responses:

if( AND ( x > low , x < high) , 1 , 2) -- nm - decline Sep 11, 12:28 9
- I misspoke, sorry. if it's in a range of cells. like if a1 is in the list c1:c100, return 1. sorry, thank youo. -- nm - amanda Sep 11, 12:30 8
  - use vlookup -- nm - decline Sep 11, 12:32 7
    - yeah, that's what charlie said too. I need to add an extra column if I do that. oh well. -- nm - amanda Sep 11, 12:34 6
      - aha. IF(ISERROR(MATCH(A3,[list],0)),"YES","NO") silly me. -- nm - amanda Sep 11, 12:41 5
        
        I [heart] iserror to fix problems with vlookup. - spamlet Sep 11, 12:45 4
        
        thanks to everyone who helped. note that the issue was not formula, but buttheadism: I forgot to anchor my range. - amanda Sep 11, 12:48 3
        
        oops! -- nm - znufrii Sep 11, 12:58
        
        That's the worst. At least you realized it quickly. -- nm - spamlet Sep 11, 12:53 1
        
        (I'll never admit it to charlie, obvs.) - amanda Sep 11, 12:54
IF(AND(a1[greater than]1, a1[less than]100)=TRUE, 1, 2) -- nm - znufrii Sep 11, 12:27

Post a message top

Replies are disabled on threads older than 7 days.