I am converting an Excel worksheet to a PDF fillable form.
The form is a series of rows and columns. The Excel formulas have not transferred and I need to create these in the calculate tab on properties. While the formulas are not complex, they are not as simple as + and x.
Column 1 = Labour Total
Column 2 = Labour Total Ex GST
Column 3 = CT 50%
Column 4 = OC 50%
I need help with two different formulas/scripts:
1. I enter the total labour in Column 1. I need Column 2 to calculate the Ex-GST labour. In excel the formula is "=A1+(A1/1.1)-A1" How do I write this in the "Simplified Field Notation"?
2. I need columns 3 and 4 to calculate 50% of the ExGST labour cost. In Excel the formula is "=A2/2". How do I write this in the "Simplified Field Notation"?
I have researched everywhere, even had a chat with an Adobe assistant but no one has been able to help me.