Novice in need of help with rental rate formula

Greetings: I am a novice that is trying to calculate rental rates with price points based on duration of rentals. @ four days discount, etc.  These individual statements work, but the series doe...