I've Excel formula that Round the value of Perticular Cell. I want to implement this formula for the PDF file.
here is the excel formula, =FLOOR(P100,1000)
As you can see it Round Down the value nearest 1000.
I've try this script to do it but it only nearest value please see attached image
If any one can help me I appreciate.
thanks in advance
Math.floor() only accepts one argument... the value you want rounded down. You'll need to divide the value by 1000 then round down then multiply by 1000 if you want to round to the nearest 1000.
Thanks for your answer, it help me a lot.