Home |
Search |
Today's Posts |
#1
|
|||
|
|||
jet boat
I own a tour boat biz and pay the pilots by the trip.
1 trip =$30.00 2 trips=$60.00 3 trips=$115.00 4 trips=$127.50 5 trips=$150.00 How do I do a fomula for this? column 1 column 2 column 3 date trips pay 1 jun 3 $115.00 |
#2
|
|||
|
|||
Take a look at the VLOOKUP function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jet Boat Ron" wrote in message ... I own a tour boat biz and pay the pilots by the trip. 1 trip =$30.00 2 trips=$60.00 3 trips=$115.00 4 trips=$127.50 5 trips=$150.00 How do I do a fomula for this? column 1 column 2 column 3 date trips pay 1 jun 3 $115.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |