Percentage calculation

Version 1

    Hi,

     

    I am trying to calculate percentage based on certain columns.  I need to check if the column A, column B and column c is NOT NULL the count 1 else 0 and finally calculate percentage also YES or NO if all the columns are present.

     

     

    For example: 

     

    Column1

    A
    BC
    PercentageE
    XXXXXXXXX3/3*100Yes
    XXXXXX2/3*100No