I'm looking for a formula that will give different result based upo
where the entry falls within a range.
Example.
If A1 is a number between 1-10 then it would return one possibl
result. (say, a cost of $5), but if it is in the range of 11-20 i
would return a different result (say, a cost of $10), and if it fall
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 tha
is where A1 gets its number.
I have tried using < and in forumalas but don't know how to construc
a formula that has both at the same time.
Any help would be very much appreciated

--
pdgoo
-----------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...fo&userid=3162
View this thread: http://www.excelforum.com/showthread.php?threadid=51319