Excel Formula

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.

This should do the trick:

=IF(A2<10,15,IF(AND(A2>9.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.

Hi Kelly

You need to use Vlookup...

Thanks
Karthik Bhat
Bangalore

=VLOOKUP(16,A1:B3,2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kelly" <[email protected]> wrote in message
news:[email protected]...
> 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.

Say you put in the miles in A1 and want result in A2. Enter this in A2
=IF(A1>=15,25,IF(A1>=10,20,15))

Simple isn't it.

Thanks
Karthik Bhat
Bangalore