Hello. forgive me I am new. I have an excel spreadsheet I created that I would like to convert to a fillable PDF (I have Acrobat Pro 7 for OSX) and it appears it can be done, but beyond simple addition or multilpication, it wants to use a javascript.

I know nothing about javascript, so I am hoping someone here can help me. :-)

its a calculator for my candle sales business. It takes the number of candles sold and tells me how many cases (12 to a case) and how many singles left over.

to determine how many cases, I have been using (in excel) =trunc({input from cell}/12)

and to determine how many single candles
={input from cell}-(trunc({input from cell}/12)*12)

I hope this makes sense. Is there a way to get the same results as a javascript to put into Acrobat Pro so I can get the PDF to do this calulation. I dont think I can send attachments on this forum, but if you email me privately I can send the excel spreadsheet so you can get an idea of what I need.

Thanks a bunch,

-=Evette=-