Logical Function Formula

[Hassan]

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

 

[Jim Cone]

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