The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

4 - Data Explorer
since ‎Jan 10, 2024
‎Jan 26, 2024

## User Statistics

• 7 Posts
• 0 Solutions
• 0 Kudos given
• 0 Kudos received

## Calculate different % if it is before specific time or after

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank: IF(    {Date Booked},    IF(     ...

## Calculate if time is date time is between specific date

I have a formula that calculates a 2.99% but since January 1 is 2.29%. Actual formula: ({Total due}-(2.99*{Total due})/100)+{Manual Rate}I have a column: Date Booked How can I modify the actual column named 2.99% to be calculated only if the Date Boo...