I've got a conundrum at work and I need some help.
We've got an Excel spreadsheet that we use as a form for some of our business and it works great for most of what we need, but because many of our users have different versions of Office (don't ask...) the digital signature requirement we have can become bothersome. Furthermore, the way Office handles digital sigs has now been deemed insufficient for our audit requirements.
PDF files on the other hand... well they handle the digital sigs like a dream.
I've managed to successfully open the Excel file in Adobe Acrobat Pro X and it makes a nice fill-able form that you can tab from field to field in, but
ALL of the formula functionality has been stripped. This is no bueno for the majority of the highly educated and extremely intelligent individuals who will be filling the form out on a regular basis - 3rd grade math is beneath (beyond?) them you see.
I've got some formulas that I need to import into this pdf file but it wants scripts - which I don't know squat about.
Here are the formulas:
=IF(I5="G","A",IF(J5="G","A",IF(I5="J","A",IF(J5="J","A",IF(I5="B","A",IF(J5="B","A",IF(I5="H","Q",IF(J5="H","Q",IF(I5="W","Q",IF(J5="W","Q",IF(I5="A","Q",IF(J5="A","Q"))))))))))))It's long and overly compliated and I know there's got to be a way to simplify the formula but my tinkering has failed so far. If you know how to shorten this without comprising functionality please let me know.This formula looks at what the user has entered in cells I5 and J5.
If they entered a G, J, or B in those cells, the cell with the formula displays the letter "A".
If they entered an H, W, or A in those cells, the cell with the formula displays a "Q".
What I really need is a translation to the type of script that Adobe requires for a fill-able form.
=IF(I5="X",L5+M5,L5-M5)This formula looks at what the user has entered in cell I5.
If they entered an X then it adds the amounts in cells L5 and M5.
If they entered anything other than an X it subtracts the amount in cell M5 from the amount in cell L5.
Clear as mud?
If anybody can help I would be greatly appreciative.
TIA!
Offices are open M-F 8am-5pm Central Time.
You can also e-mail the Chief Brand Officer directly to try to resolve questions/stuff at
for help with password resets, general customer service questions, store order resolution, credit card store updating, questions about comic books and CCL, etc...