ST Alpha - "what's it called in excel where "if number is between column a and column b, return column c"? like basically a table of min and max values for levels" (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: 153

what's it called in excel where "if number is between column a and column b, return column c"? like basically a table of min and max values for levels

Posted by ☀️ mandy chem ☀️ (aka amanda) Jul 30 '24, 13:11

thanks I can't think of how to google it

Responses:

this I think? -- (link) - ☀️ mandy chem ☀️ Jul 30, 13:19
AND formula? - Roger More Jul 30, 13:17 4
- I have nine levels. that would be one hell of an if. -- nm - ☀️ mandy chem ☀️ Jul 30, 13:23 2
  - It sounds like you're trying to do multiple comparisons of values in a single cell/function. - Fuzzy Jul 30, 13:48 1
    - I used xmatch to return "which line is my data on" and then an xlookup to return the corresponding decrement level. it's not super elegant - ☀️ mandy chem ☀️ Jul 30, 14:12
- This is the solution I was thinking of, wouldn’t be surprised if there’s a more elegant one out there though. -- nm - znufrii Jul 30, 13:19
Try this - loosilu Jul 30, 13:15 3
- sorry I can't say what I mean so I can't google it. - ☀️ mandy chem ☀️ Jul 30, 13:17 [Attachment] 2
  - did it not work? -- nm - loosilu Jul 30, 15:49
  - note that this is just a few lines. I could if it if it were just three lines. -- nm - ☀️ mandy chem ☀️ Jul 30, 13:18

Post a message top

Replies are disabled on threads older than 7 days.