Excel to Custom Calculation Script

How would this Excel formula translate to a custom calculation script in a PDF form?

=IF(A4<=10, 16.68,16.68+((A4-10)*1.67))

Thanks!

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

You can use this code as the custom calculation script of your field, then:

var v = Number(this.getField("Same_Day_Miles").valueAsString);
if (v<=10) event.value = 16.68;
else event.value =16.68+((v-10)*1.67);

Community Expert

What's the name of the "A4" field in the PDF?

Translate

Participant

"Same_Day_Miles"

Translate

Correct answer

Community Expert

You can use this code as the custom calculation script of your field, then:

var v = Number(this.getField("Same_Day_Miles").valueAsString);
if (v<=10) event.value = 16.68;
else event.value =16.68+((v-10)*1.67);

Translate

Sign up