Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do I write an IF(VAT@20% // VAT@5%) code for hotels

Solved
Jump to Solution
169 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Any ideas how to write an IF code for hotel VAT?

I have 50 hotel nights showing in column {Nights} multiplied by the {nightly rate} @ £200/night = £10,000

VAT is calculated @ 20% on top of the first 28 nights and then @ 5% from the 29th night onwards.

I would love a formula that can calculate this.

1 Solution

Accepted Solutions

Welcome to the Airtable community!

Does this work for you?

SUM(
  (
    IF("VAT rate for first 28 nights", 0.2) 
    * IF({Nights} <= 28, {Nights}, 28) 
    * {nightly rate}
  ),
  (
    IF("VAT rate for nights 29+", 0.05)
    * IF({Nights} > 28, {Nights} - 28, 0) 
    * {nightly rate}
  )
)

See Solution in Thread

2 Replies 2

Welcome to the Airtable community!

Does this work for you?

SUM(
  (
    IF("VAT rate for first 28 nights", 0.2) 
    * IF({Nights} <= 28, {Nights}, 28) 
    * {nightly rate}
  ),
  (
    IF("VAT rate for nights 29+", 0.05)
    * IF({Nights} > 28, {Nights} - 28, 0) 
    * {nightly rate}
  )
)

Oh wow – that worked! Amazing! Thank you so much!