Hi all, apologies if this has been answered as the forum software won't allow searches for the word "between"!
I need to check if a monetary value (2 decimal places) is between two numbers. I've been using the usual if(and()) approach but it's sooooo clunky. I found the MEDIAN approach and like it, but it only seems to work for integers.
Is there a tidy way to evaluate if a decimal value is between two other (potentially also decimal) values?
Thanks!
EDIT: I may have been mistaken about the MEDIAN approach only supporting integers, I think I just did it wrong. Still I'd be interested to know if anyone has any other clever solutions to this.
I need to check if a monetary value (2 decimal places) is between two numbers. I've been using the usual if(and()) approach but it's sooooo clunky. I found the MEDIAN approach and like it, but it only seems to work for integers.
Is there a tidy way to evaluate if a decimal value is between two other (potentially also decimal) values?
Thanks!
EDIT: I may have been mistaken about the MEDIAN approach only supporting integers, I think I just did it wrong. Still I'd be interested to know if anyone has any other clever solutions to this.
Last edited: