Good Day Please advise if Jotform Tables can do the following calculations: 1. Stamp Duty Calculation (whereby the Annual Rental, say $10,000 is tak

Good Day

Please advise if Jotform Tables can do the following calculations:

1. Stamp Duty Calculation (whereby the Annual Rental, say $10,000 is taken, divided by 1000, answer is converted with ceiling up, multiply answer by 5,

2. Work out percentages for e.g what percentage is 300 square metre out of 1200 square metre

3. Work out Rate per square metre in rental market ( Rental is $10,000 and space leased is 350 square metre)

4. Work out the rental escalation of 7% over each of a 5 year lease starting with

$ 10,000 per month in Year 1

5. Deposit Payable (by taking the Deposit Amount Required, Less the Deposit on Hold, = Deposit Payable)

6. Given the Start Date, say 1 Oct 2024, and duration of the lease in months, for e.g 60 months, can Jotform Tables calculation the End Date of the lease

Hi Danny,

Thanks for reaching out to Jotform Support. Keep in mind that Jotform is an online form builder that enables businesses to create customized forms to collect and organize essential data. Jotform can handle some types of calculations, though some might require the use of form calculation widgets or custom formulas within the table.

You can set up the calculation like for example, to perform Percentage Calculation, you can use a simple formula to calculate percentages. For example, the formula to calculate is "What percentage is 300 sqm out of 1200 sqm" would be: =(300/1200) * 100. But please note that calculation features of Jotform may not support other complex calculations.

Let us know if you have any other questions.