Calculate %

[rahul_oberoi]

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

[#2]

@rahul_oberoi You can try-

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

[#3]

Hi @rahul_oberoi 

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

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