Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Script for If function calculation.

Community Beginner ,
Apr 14, 2021 Apr 14, 2021

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. 

TOPICS
PDF forms
461
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 14, 2021 Apr 14, 2021

Try the forum for Adobe Acrobat.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 14, 2021 Apr 14, 2021
LATEST

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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines