Question

# Do you know how do I calculate it up to a maximum of 5 nights?

• 3 replies
• 16 views

• Beginner

Hi,

I do calculate at city tax whit Zapier formula but i have the payment maximum of 5 consecutive nights.

I have this formula IF(71>= 70.99, IF(71 <= 120.99, "4", 5), 3).
Do you know how do I calculate it up to a maximum of 5 nights?

Thanks a lot

### 3 replies

Userlevel 7
+14

Hi @Raff

Perhaps you can outline some examples for us (w/o formulas) to help us understand the inputs and desired outputs.

Userlevel 1

Hi @Troy Tessalone ,

I have to calculate my amount based on the rate that the customer pays but I will have calculate for maximum 5 nights

from 1€ to 70,99€  pay 3 euro
from 71 to 120,99€ pay 4€
over 121€ pay 5€

I have to calculate this for a maximum of five consecutive nights

Ex. if have a reservation of 6 nights and the guests pay 75€ for nights the calculation will be:

4€ x 6 nights = 20€

It’s better now?

Thanks a lot

Userlevel 7
+14

@Raff

Try asking ChatGPT for help constructing the formula.