Forum Discussion
rahul_oberoi
Aug 21, 2022Copper Contributor
Calculate %
Hi Experts, Need your help to calculate A2: on Value of B2 , C2 and D2 . If values are completed Value of A1 should be 100 % If B3 & C3 & D3 - if one the field is pending Value A3 shoul...
Aug 21, 2022
Hi rahul_oberoi
You would use this formula, and change the cell A2 format to %
=COUNTIF(B2:D2,"completed")/3