Calculate %

Occasional Contributor

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 should be % of the value  B3 & C3 & D3

 

rahul_oberoi_1-1661146833664.png

 

2 Replies

@rahul_oberoi You can try-

=IF(COUNTIFS(B2:D2,"Pending")>0,"0%","100%")

Harun24HR_0-1661149248622.png

 

 

Hi @rahul_oberoi 

 

You would use this formula, and change the cell A2 format to %

=COUNTIF(B2:D2,"completed")/3