Forum Discussion

Qrew Captain

7 years ago

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...

Tables and fields

QuickBaseCoachD

Qrew Captain

Try this

If(
[Rental Days]=0.5,[Rental Days]*[Rental Item - Daily Rate],

[Rental Days]>=1 or [Rental Days]=4 or [Rental Days]=25, [Rental Days]*[Rental Item - Monthly Rate])

QuickBaseCoachD

Qrew Captain

7 years ago

Sorry, Dirk, I see that my iPhone answer got garbled. You seem to have this well in hand now.