Thank you so much lateniteNC.  I was stumped on why the formula wouldn't work and I did a little more digging and I found a script that was written in the ALL EVENT script editor that was giving me the error codes.  I removed the script and everything is working perfectly. Thanks again.

hey lateniteNC, I can't seem to figure out how to upload my form into the forum.  Have any recommendations on how I can do that?

Hi lateniteNC,  thanks again for all the help.  I imputed the formcalc code in and this is what im getting:I replaced the Field 1, 2, 3 with the names appropriate to the names on the worksheet.Again thanks for all the help.  I am super super noob when it comes to this..

Hi lateniteNC,  thanks again for all the help.  I imputed the formcalc code in and this is what im getting:I replaced the Field 1, 2, 3 with the names appropriate to the names on the worksheet.Again thanks for all the help.  I am super super noob when it comes to this..

hi latenite..thanks for responding.I am not familiar with writing an ( if..then statement.)  I know where I need to write it but what would the if statement look like if possible?

The fields are set to default zero.  The  fields are set where the users have the option to fill in a numeric value.  If no value has been inputted, then the value is zeroThanks geegee for replying

I'm trying to creating a form where there will be 3 fields.  two numeric fields and a third numeric field where I'd like to show the total percentage ex: field A 70 / field B 100 *100 = Field C (Total Percentage) but I keep getting a arithmetic underflow error.  Need some helpI thought it would be s...