Converting an Excel Formula into a Fillable Form

Question

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 · Answer

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)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded