Hi guys. Need a bit of help!
I am trying to construct a True/False formula, where it is True when the value of the cell lies between 0.9 and 1.1, or 1.9 and 2.1, or 2.9 and 3.1.
Am banging my head against the wall in frustration as I'm getting nowhere!
Anyone out there able to save my headache, not to mention my wall??!!
Hi,
Try this for now
=IF(AND(A1>=0.9,A1<=1.1),TRUE,IF(AND(A1>=1.9,A1<=2.1),TRUE,IF(AND(A1>=2.9,A1<=3.1),TRUE,FALSE)))
Will try to shorten
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Works like a charm!
Thank you SO much! Have been out of bed since 6am trying to figure this out! Much appreciated!
No problem
This is a little shorter
=IF(OR(AND(A1>=0.9,A1<=1.1),AND(A1>=1.9,A1<=2.1),AND(A1>=2.9,A1<=3.1)),TRUE,FALSE)
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks