Script for If function calculation.

[Bhuwesh]

Hi Everyone. 
I am looking for script for if calculation in pdf. The formula according to excel is - =IF(ISERROR(COUNTIF(C2:C17,"Y")/(COUNTIF(C2:C17,"Y")+COUNTIF(C2:C17,"N")+COUNTIF(C2:C17,"P")))," ",COUNTIF(C2:C17,"Y")/(COUNTIF(C2:C17,"Y")+COUNTIF(C2:C17,"N")+COUNTIF(C2:C17,"P")))

The excel file is attached if you don't able to download, please see the link "https://drive.google.com/file/d/1Xv31pkHmvRnzg-6k_bbNUd-mOeFMeAvy/view?usp=sharing" . I want to achieve that calculation and also want the color of Y, N, P and NA appear according to excel file. I think posting here will help me to solve my issue. 

[Bernd Alheit]

Try the forum for Adobe Acrobat.

[try67]

What are the names of the fields in the PDF files? Which part of this formula do you not know how to implement in JS?