My fields are "install", "monthly", "day", "dayrate" and "prorate". ("monthly" and "install" are the only fields that require input from the user.
dayrate = monthly / 30 day = 31 - install
I am trying to determine "prorate" based on what is input in "monthly" and "install." The formula I used in Word to calculate the value for the field “prorate” is “IF(day=30, monthly, day*dayrate).
Is there a way to do this in Acrobat? I have tried mimicking several other “IF” scripts without success and I’m in a time crunch. Thank you much!
You do not specify the target of the calculation, as it is assumed the target for the result of the calculation is the field for which the calculation is being written.
The target of the calculation is to determine "prorate."
"prorate" will always equal "day" x "dayrate" unless "day" = 30, in which case "prorate" would equal "monthly" which is an amount entered by the user.
Let me know if I did not answer your question. Thank you!
Europe, Middle East and Africa