calculating per hour earnings for drivers with a few variables

[HOTTRUCK]

I am trying to calculate how much a driver actually makes during a delivery based on different vehicle types. I have a calculator that factors in a few things and I have been manually running the numbers through it. Could anyone provide some help on a formula that I can plug into this sheet to perform this task? Here are the relationships I am trying to create in the equation.
AN2=Column AB
AO2=Column AC
AP2=Column AE
These variables get input into the calculator and i would like for column AJ to populate the result (Column AT)
The problem I am having is making column AJ give me the result based on the driver vehicle (Column AA)
im new here so Let me know if I didnt get the sheet put in here correctly. Im on a mac.

delivery data 3-13.xlsx
	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW
1	Driver Vehicle	Driver Pay	Total Miles	Total Minutes	Total hours	Miles DIF	Milutes DIF	Hours DIF	PER HOUR	ACT per hour				pay	miles	hours
2	MOTORCYCLE	83.15	59.9	106.0	1.8	59.9	106.0	1.8	$ 47.07	39.25				83	115	2
3	MOTORCYCLE	22.21	35.5	49.0	0.8	0.8	-11.0	-0.2	$ 27.19	18.65				pay	Miles	gas	tolls	hours	MPG	per hour	earnings	gas price
4	MOTORCYCLE	44.35	35.3	59.0	1.0	-29.7	-35.0	-0.6	$ 45.08	37.06			CAR	$ 83.00	115	12.50	$ -	2.00	23	$ 35.25	$ 70.50	$ 2.50
5	TRUCK	40.12	71.5	64.0	1.1	0.9	-24.0	-0.4	$ 37.60	29.03			TRUCK	$ 83.00	115	17.97	$ -	2.00	16	$ 32.52	$ 65.03	$ 2.50
6	CAR	21	77.6	62.0	1.0	-14.5	-45.0	-0.7	$ 20.31	11.48			MOTORCYCLE	$ 83.00	115	23.96	$ -	2.00	12	$ 29.52	$ 59.04	$ 2.50
7	CAR	29.92	12.8	17.0	0.3	12.8	17.0	0.3	$ 105.60
8	CAR	27.84	33	57.0	1.0	33	57.0	1.0	$ 29.31
9	TRUCK	46.19	23.6	62.0	1.0	22.6	61.0	1.0	$ 44.70
10	MOTORCYCLE	39.92	27.6	59.0	1.0	27.6	59.0	1.0	$ 40.60
11	MOTORCYCLE	39.92	43.1	99.0	1.7	14.4	70.0	1.2	$ 24.19
Sheet1

Cell Formulas
Range	Formula
AC2:AC11	AC2	=N2+O2+S2
AD2:AD11	AD2	=W2+X2+Y2+Z2+(R2/60)
AE2:AE11	AE2	=AD2/60
AF2:AH11	AF2	=AC2-P2
AI2:AI11	AI2	=F2/AE2
AN4:AO4	AN4	=AN2
AP4:AP6	AP4	=(AO4/AS4)*AV4
AN5:AO5	AN5	=AN2
AN6:AO6	AN6	=AN2
AT4:AT6	AT4	=AU4/AR4
AU4:AU6	AU4	=AN4-AP4-AQ4
AR4	AR4	=AP2
AR5	AR5	=AP2
AR6	AR6	=AP2

 

[sykes]

Hi, and Welcome to Mr. Excel!

Firstly, well done on using the forum tools to lay out your project, enabling folks to have a good idea what you already have.
Secondly, well done on trying to accurately describe what you already have, and what you're trying to achieve; many posters don't, which ends up in forum helpers having to send numerous posts to-and-fro to try and crow-bar out of the poster what they're trying to do.
Thirdly, rest assured, someone CAN help you with your project; there are some very, very switched-on Folk, here (of which I'm not one, unfortunately for you!).

That having been said, I'm having difficulty understanding some of what you actually want to achieve, and I'm guessing that this is why nobody's replied yet!

You say that you're "trying to create a relationship, where AN2=Column AB..." etc etc
I don't yet understand how the Pay cell in AN2, can equal a whole column. AN2 currently displays "83." Is this taken from cell AB2 (83.15) and trimmed, or rounded down? You'll need to find a different way of explaining what you want to achieve, here. Do you mean, for example, that you want AN2 to be capable of having the AB (Driver Pay) column values populated into it, so that you could pick a Driver Pay figure from a list of the Col AB values?

I'm also having difficulty understanding your requirement for "...column AJ to populate the result (Column AT)."
Could you try and explain this need, in a different way, perchance?

Please don't take my points/questions as criticism - they're not - just trying to help you to get over to the members what you want, so that you can get help, and will therefore want to come back for more, in the future.

One other point - ref your request to let you know if you got the sheet put in correctly; basically, yes, -my only comment would be that because your sheet image is so large, I've found myself having to scroll a lot, whilst trying to work out what's where. It may have helped on this occasion, after having got your image onto your post, to have re-sized it to a smaller area (just grab a corner & drag - the same way you would with re-sizing anything else.
That having been said, I'm a Windows user for this kind of thing, so don't know what you can & can't do on a Mac, in this regard.