Skip to main content
Known Participant
April 14, 2021
Question

Script for If function calculation.

  • April 14, 2021
  • 2 replies
  • 590 views

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. 

This topic has been closed for replies.

2 replies

try67
Community Expert
Community Expert
April 14, 2021

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?

Bernd Alheit
Community Expert
Community Expert
April 14, 2021

Try the forum for Adobe Acrobat.