How do I make a function that checks if all numbers i a column are in between two defined values and returns true/falls?
/Andreas
How do I make a function that checks if all numbers i a column are in between two defined values and returns true/falls?
/Andreas
Try this, A1 is where i have the lower No and B1 the higher value the list of Nos are in Column C and formula in D1 dragged down, adjust according to your sheet.
GMWPHP Code:
=IF(AND(C1>=$A$1,C1<=$B$1),"True","False")
Thank you for your reply. This works, but it only checks one number (in your case "C1"). I get that i can just drag this to check all numbers if they are true or falls, but my criteria is that a lot of numbers that needs to be within a specific range, so I want to mark a full column of numbers and let excel tell me if all numbers are within that specified range. I hope that makes sense.
AKJ
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
How about
=COUNTIFS(E:E,">="&F1,E:E,"<="&G1)-COUNT(E:E)=0
Where F1 has the lower limit & G1 the upper.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks