These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

if then formula

annac
Registered: Mar 13 2008
Posts: 8
Answered

I don't have much experience with using the form function in acrobat and need some help with a calculation. It could be pretty easy for someone who knows what they are doing!

The pdf form I am creating will allow a customer to type in the quantity of a product and then see how much it will cost them. The spreadsheet will span 3 pages. Each page will have a total at the bottom with the grand total on page 3. If this grand total amount ($) is $500 or more than 10% will be taken off the grand total.

I cannot figure out how to get the 10% off ONLY if the grand total gets to be >=500.

any thoughts?

Thank you,
Anna

My Product Information:
LiveCycle Designer, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
If you are using FormCalc, then your final calculation would look something like this

var val = Sum(...Input Fields...)
if(val >= 500) then
val * .9
else
val
endif

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

annac
Registered: Mar 13 2008
Posts: 8
Thank you, this works perfectly.