This should do the trick:

=IF(A2<10,15,IF(AND(A29.99,A2<15),20,25))


"Kelly" wrote:

In One sheet I have a chart that has miles and pay.
A B
0 $15
10 $20
15 $25

I want to be able to put in one cell the ammount of miles and in another
cell it will automatically give me the pay. if it is 0-9.99 miles it is $15
and 10-14.99 miles it is $20. I have written a formula before but I can not
seem to remeber how I did it.