excel If I put 1 in colum b I want it to = $30.00 in colum c same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a boat driver gets paid by the trip. I put the days of the month in colum
A. now in colum B I want the number 1 (which represent the number of boat
trip done that day)To equal $30.00 in colum c same row.
If he does 2 trips = $60.00,
3 trips = $115.00
4 trips = $127.50
5 trips = $150.00

office 2000 excel
 
Back
Top