Hi Experts,
Need your help. What i need is to calculate the final score in column "I". All parameters have weightage except M(Fatal) parameter.
I have tried the formula in Column I however, i'm, not able to do distribution of score in parameters.Please help me in calculating the score on basis of below conditions:-
If Parameter M(Fatal) is No, then total score would be 0
If any parameter is "No", then its score should get deducted from final score.
if any of parameter is NA then its score must be distributed in rest of the parameters.(Not to M(Fatal) parameter)
Final score is 100 if all are Yes.
I need the formula in Colum "I" for Score.(Distribution of Score in case of "NA" should be calculated here.)
Data in K: P are the values for "Yes" & "No" of data in B:H.
Need your help. What i need is to calculate the final score in column "I". All parameters have weightage except M(Fatal) parameter.
I have tried the formula in Column I however, i'm, not able to do distribution of score in parameters.Please help me in calculating the score on basis of below conditions:-
If Parameter M(Fatal) is No, then total score would be 0
If any parameter is "No", then its score should get deducted from final score.
if any of parameter is NA then its score must be distributed in rest of the parameters.(Not to M(Fatal) parameter)
Final score is 100 if all are Yes.
I need the formula in Colum "I" for Score.(Distribution of Score in case of "NA" should be calculated here.)
Data in K: P are the values for "Yes" & "No" of data in B:H.
