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

Hassan,
This will get you close, but you will have to watch the y and n entries.
With your data starting in B6 to E6...
=IF(B6=100,70+COUNTIF(C6:E6,"Y")*10,B6*0.7)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Hassan"
wrote in message
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