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

[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

 

[Bill Kuunders]

=IF(B3=3,115,IF(B3=4,127.5,B3*30))

regards
Bill K

 

[Don Guillett]

Have a look in HELP index for CHOOSE