math operators ><=

I am looking for a way to find a number that is between two numbers. I know >=, and <=, but what about between two numbers. I can't figure out a formula that follows that formula. Help!

Dave, I didn't explain myself very well. I have a row of numbers and I am trying to calculate a selling price based on volume. If the quantity is between 1 and 25 then use one value if it is greater than 25 but less than 50 then use another number, and if greater than 50 use another. I can do the less than 25 and the greater than 50 but how do i do the between 25 and 50. I am using an 'if' formula and it works fine except for this one section?

Chris

=and(>=25,<=50)

I think you are close. Here is what I have
A B C D E
1 Quantity 1-9 10-25 25+ Total

2 21 5.25 4.75 4.25 89.25

Here is a part my E2 formula, I am trying to get E2 to automatically pick the right $ based on quantity. I know this is simple, just can't get there.

=IF(A2<10,B2*A2,IF(A2>=10???,C2*A2),IF(A2>=25,D2*A2))

Help! If there is a simpler way, let me know

Thanks
Chris

it didn't post like i drew it out. Shift all of the numbers adn letters over.