ST Alpha - "AND formula?" (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

In response to "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" by ☀️ mandy chem ☀️

AND formula?

Posted by Roger More (aka RogerMore) Jul 30 '24, 13:17

=IF(AND(X>A2,X<B2),C2,0)

Responses:

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

Post a message top

Replies are disabled on threads older than 7 days.