I'm looking for a formula that will give different result based upon where the entry falls within a range.
Example.
If A1 is a number between 1-10 then it would return one possible result. (say, a cost of $5), but if it is in the range of 11-20 it would return a different result (say, a cost of $10), and if it falls within a range of 21-30 it would return a different cost (say, $20) etc.
A1 would be referencing another cell that has its own formula and that is where A1 gets its number.
I have tried using < and > in forumalas but don't know how to construct a formula that has both at the same time.
Any help would be very much appreciated.