Script for If function calculation.

New Here ,
Apr 14, 2021 Apr 14, 2021

Copy link to clipboard

Copied

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

Views

69

Likes

Translate

Translate

Report

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
Adobe Community Professional ,
Apr 14, 2021 Apr 14, 2021

Copy link to clipboard

Copied

Try the forum for Adobe Acrobat.

Likes

Translate

Translate

Report

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
Adobe Community Professional ,
Apr 14, 2021 Apr 14, 2021

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

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