AnsweredAssumed Answered

logic in the calculation

Question asked by grabo on Jan 26, 2018
Latest reply on Jan 29, 2018 by beverly

I have a logic problem. I would like to set prices to climb. I will give you an example without putting any currency, but only to make people understand.

From 1 to 5 hours: 25

above 5 hours: 20

above 10 hours: 15

above 15 hours: 10

 

well ... if I have 5 hours then I turn 125

but if I have 6 become 120 ... that are less!

 

I would like to find a formula that solves this problem.

In short, I would like to manage falling prices if the hours increase, but without creating anomalies like the one described.

Outcomes