Need help with IF, AND function

Hello,

I need to use multiple IF and AND functions in an Excel formula. What I need is that if anyone were to enter a certain number within the ranges as mentioned below:
If number falls within range <=105, then give result "100"
If number falls within range >105, <=120, then give result "110"
If number falls within range >120, <=142, then give result "135"
If number falls within range >142, <=165, then give result "150"
If number falls within range >165, <=190, then give result "180"
If number falls within range >190, <=210, then give result "200"
If number falls within range >210, then give result "Not in Range"

my result should pick up the corresponding value. I need to integrate this formula on my website. I've been trying my luck with the formula, though I'm constantly getting an error message. Not sure where I am going wrong. Any help would be appreciated! Thanks..

The formula I used was something like:
=if(A1<=105),"100",if((AND(A1>105,A1<=120),"110",if((AND(A1>120,A1<=142),"135",if((AND(A1>142,A1<=165),"150",if((AND(A1>165,A1<=190),"180",if((AND(A1>190,A1<=210),"200"),""))))))))))))

For the second criterion, as you have already tested for the first then you don't need to test for it again. So, you can do this:

=if(A1<=105,"100",if(A1<=120,"110",if(A1<=142,"135",if(A1<=165,"150",if(A1<=190,"180",if(A1<=210,"200",""))))))

You should note that the numbers returned will be text values as you have enclosed them within quotes - if you need proper numbers then remove the quotes.

Hope this helps.

Pete

Perfect! Thanks Pete!