Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Calculate Multiple Mileage Rates in Excel?
I am creating a spreadsheet to track my miles and pay. I'm having a difficult time calculating the mileage pay. I get paid different rates based on the number of miles. Is there a way to calculate the pay based on different mileage rates? Below is an example.
If I have 0-75 miles, I am paid $.52 cents per mile.
76-125 miles is $.50 cents per mile
126-200 miles is $.49 cents per mile
201-300 miles is $.46 cents per mile
301-2500 miles is $.41 cents per mile
Is there a way to create a formula for this?
Thanks!!!!
2 Answers
- expletive_xomLv 75 years agoFavorite Answer
you should probably use a VLOOKUP() for this.
but since its only 5, you can also use a LOOKUP()
- put a random mileage number in cell A1
- then copy&paste this in B1
=LOOKUP(A1,{0;76;126; 201;301},{0.52;0.5; 0.49;0.46;0.41})
it should give you your proper mileage.
change A1 randomly to test.
let me know how that works.
you might also want an IF() function that makes the cell in the B column look blank if the cell in the A column is blank.
then i guess in C1 you can use a simple =A1*B1
select both cells and drag it down...then you can just put numbers in the A column.
