•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Check whether a cell is between 2 different ranges
I've got a form that we currently have two versions of, one for our 12 bit system and one for our 14 bit system. I'm trying to combine the two into one singular form.
Part of our checks need us to validate whether our value falls within the acceptable range, but the range is different for the 12 and 14 bit system. Lets say the range is 3000-3500 for 12 bit, and 12000-13000 on 14. The current form has:
IF(F20>3500, "FAIL",IF(F20<3000,"FAIL","PASS"))
I'm not sure how to get the formula to check between two ranges. I suppose I could just put the limits on some backend page and have it very between the two with conditional formatting instead of a formula?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#cell
#range
#12 bit system
#14 bit system
#formula
#validate
#acceptable range
#F20
#combine
#conditional formatting
#form validation
#current form
#backend page