Copy link to clipboard
Copied
Hallo,
ich muss ein einfaches bearbeitbares Formular aus einer Excel Datei erstellen. Ich tue mich aber mir den Berechnungen schwer.
Es sind ein paar einfache Berechnungen:
1. Es muss die Differenz von 2 Feldern berechnet werden und davon dann die Abweichung in Prozent: =(H4-F4)/F4
2. Eine Mittelwertberechung =MITTELWERT(G48:G50)
Wie bekomme ich das hin?
Copy link to clipboard
Copied
Hi Andreas
Hope you are doing well and sorry for the trouble.
The Calculate tab appears in the Properties dialog boxes for only text fields and dropdown boxes. Use these options to perform mathematical operations on existing form field entries and display the result. Please go through the help pages listed below and see if that works for you.
https://helpx.adobe.com/acrobat/using/pdf-form-field-properties.html
https://acrobatusers.com/tutorials/how-do-i-use-basic-calculations-in-a-form/
Regards
Amal
Copy link to clipboard
Copied
This can be done using a script. Be aware that when dividing by a value of a field you must first make sure that field is not empty (or zero), as that would result in an error.