Donate SIGN UP
Home > Technology > Computers > MS Excel - IF Formula with values between

MS Excel - IF Formula with values between

Avatar Image
gaz_farr | 09:14 Tue 31st Jul 2007 | Computers
3 Answers
Hi.
I need an IF Formula to work if i want to return results between certain values. eg. IF A1 is between 10 and 20 return this, if it isn't return this

Any help would be wildly appreciated.

Thanks
prev All in one media player
  
next Defrag
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by gaz_farr. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image CheekyChops
Try something like this:

=IF(A1<11,"rubbish",IF(A1<21,"Not Bad",IF(A1<31,"great","Fantastic!I")))

Under 11 returns rubbish
11-20 returns Not Bad
21-30 returns Great
over 30 returns Fantastic!

Obviously tailor the outcomes to whatever you want it to say.
11:10 Tue 31st Jul 2007
Avatar Image Kerplunk
=IF((AND(A1>10,C2<20)),"yes","no")
11:16 Tue 31st Jul 2007
Avatar Image Kerplunk
Sorry that should read:

=IF((AND(A1>=10,A1<=20)),"yes","no")
11:16 Tue 31st Jul 2007

1 to 3 of 3rss feed

Do you know the answer?

MS Excel - IF Formula with values between

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.