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




2 Replies

@rahul_oberoi You can try-





Hi @rahul_oberoi 


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