Logical Function / Formula
 

Can some one help me with logical function for the following

WC QC Sub App % Complete
70% 10% y or n y or n

100% 100% y ---

100% y ---

Basically first column is work completion for me (70% weightage), second
column QC check (10% weightage) and this column is Submission (10% weightage
and denoted by €œy€� or €œn€�) and forth column is Approval (10% weightage and
denoted by €œy€� or €œn€�)

Technically once the Work is completed it should go to QC and so on and for
calculation it should not consider the values if previous stage is not
complete.

Logically I want answer in % Complete as
70% of 100% of WC+10% of 100% of QC (WC being 100 for that row)+10 (if it is
€œy€� in sub column and WC & QC being 100 for that row)+ 10 (if it is €œy€� in
App column and WC, QC being 100 and €œy€� in €œSub€� for that row)

If any condition does not satisfies it should terminate summation upto
previous column

Thanks on & All for being on this platform
Hassan