Skip navigation
Sarida813
Currently Being Moderated

Retaining Excel formulas

Aug 27, 2012 5:11 PM

Tags: #forms #fillable #formulas #excell

I've created a fillable invoice in Excel with formulas to add totals, subtract discounts and include tax. Can these formulas be retained when converting the invoice to PDF in Acrobat X? We would like to use the PDFs on our iPads.

 

So when the sales rep fills out the cost of each item, it is automatically added, discounts are automacally deducted and when the tax rate is entered, the correct tax dollar amount is added.

 
Replies
  • George Johnson
    9,224 posts
    Aug 11, 2002
    Currently Being Moderated
    Aug 27, 2012 5:21 PM   in reply to Sarida813

    They can't be retained from Excel, but the calculations can be redone in Acrobat, using either one of the built-in methods or with JavaScript.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points