Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

FormCalc Help


Level 2

Here is a link to a form that is giving me a headache!  You will get an error when you try to open the form (which is my issue), but if you click "ok" you should be able to view the form.

I will try to explain what I am trying to accomplish...  In column 9 of my first table my end user will enter a "Y" or "N".  The Value column will either be equal to column 6 if column 9 is "N" or will need to be multiplied by 2 if column 9 is "Y".  For some reason I am not able to define "textfield9" properly so that FormCalc recognizes it.  I have tried so many different possibilities and still get an error.

Please help!  Thanks   

3 Replies


Level 10


try this script.

if (Upper(TextField9) eq "Y") then

     $ = TextField5 * 2


     $ = TextField6



Level 2

You are amazing! It worked! Thanks so much for your help both today and yesterday.

Susann K. Wenzl

Curriculum, Instruction, and Innovation Team

Nebraska Department of Education

301 Centennial Mall South

Lincoln, NE 68508

Phn: 402-471-6692

Fax: 402-471-0117


Level 2

Thanks for your help both today and yesterday!  You are awesome!