Hi everyone,
Does anyone know the way to express a number range in a formula?
E.G =IF(OR(A1>1, A1<4) "example1" )
I'm trying to say if A1 is bigger than 1 and smaller than 4, so in the range of 1-4 it would equal example 1.
I have decimal numbers like 2.2 that do not apply to the rule if I use the formula >1, <4 so i'm looking for a way to include decimal numbers too!
Any help would be very appreciated!
Thank you!
deleted due to wrong posting
Last edited by samba_ravi; 08-10-2017 at 08:55 AM.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
"I'm trying to say if A1 is bigger than 1 and smaller than 4"
Errm, nope. You've used OR() If you want and you should be using AND()
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
So this, maybe?
=IF(AND(A1>1, A1<4) "example1" )
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.
Re: The Symbol to show a number range in a formula
Great thank you !
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
You've saved me so much time, thank you very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks