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.