$$Excel-Macros$$ Re: Need Help in calculation of score

2016-01-07 Thread Mandeep Baluja
> > Hey check this out !! >> > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles

$$Excel-Macros$$ Re: Need Help in calculation of score

2016-01-07 Thread Mandeep Baluja
Hey SG, It's very difficult to understand your query what you wish or what you want to achieve as may be we both are using different terminology or might be explanation. Sorry to say Hope someone will help you with these given below instructions as I am not able to matchup the aim. You Wrote:

$$Excel-Macros$$ Re: Need Help in calculation of score

2016-01-07 Thread SG
Hi Mandeep, Please refer to the comment in attached sheet. I hope it would get clear now. :) On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote: > > Hey SG, > > Correct me if I am wrong !! > 1)If Parameter M(Fatal) is No, then total score would be 0 Formula should > be =

$$Excel-Macros$$ Re: Need Help in calculation of score

2016-01-07 Thread SG
Hi Mandeep, Sorry for the confusion. 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. PFA updated sheet. The difference in headers are typo