Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Hi Kelly
You need to use Vlookup... Thanks Karthik Bhat Bangalore |
#4
|
|||
|
|||
=VLOOKUP(16,A1:B3,2)
-- HTH RP (remove nothere from the email address if mailing direct) "Kelly" wrote in message ... 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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |