Converting an Excel Formula into a Fillable Form

[Maree5FA9]

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. 

[try67]

It's exactly the same, only you need to enter the field names instead of the cell names, and drop the "=" symbol.

One additional complication is that if the field name contains spaces you have to espace them, by adding a back-space before them.

So if "Labour Total" is the equivalent of "A1" then you need to specify it like this:

Labour\ Total

However, your formula doesn't make much sense... This:

=A1+(A1/1.1)-A1

is exactly the same as just:

=(A1/1.1)

[Maree5FA9]

Thank you so much for your help. 

I have removed the = and the spaces and it has worked. 

You're a legend.

[try67]

Glad to hear it. Just to clarify, though, it won't always work. Only if you use simple math operators.

If you need to use functions, if-conditions, etc., you would need to convert the formula into a custom script.

[wallaceb57801588]

try67

where does all this go?  I'm struggling with calculations.  So I have a form with Text4, Text5, and Text6 that I need to sum and display in Text7

not sure where to put the calculation?  I assume it's in the properties of Text7 but I can't for the life of me figure out where

thanks in advance

[try67]

Under the Calculate tab of Text7.