Hi, this is my first post here.. I got a question in which I can't figure out how to use the IF and AND functions to calculate question like these:
Tim parked a car in X Parking Lot.
The rates are
For the first hour, the cost would be $5
For the second hour, the cost would be $6.50
For the third and subsequent hours, the cost would be $7.50
I need to calculate, using the IF and AND functions, the amount due after each hour and the total amount due if he parked for 5 hours. Any help is really appreciated. Thanks!
Bookmarks