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

DirkRuana

Qrew Captain

7 years ago

Dan:

Excellent. I really appreciate you taking the time.
I think I need to use the ranges indicated below for correct pricing. Is my use of "AND" correct?

[Rental Days]
*
If(
[Rental Days] =.5, [Rental Item - Daily Rate],
[Rental Days] >=1 AND <= 3, [Rental Item - Daily Rate],
[Rental Days] >=4 AND <= 24, [Rental Item - Weekly Rate],
[Rental Days] >24,[Rental Item - Monthly Rate]
)