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