$$Excel-Macros$$ Re: Need Help in calculation of score
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 errors. Regards, SG On Thursday, January 7, 2016 at 1:11:40 PM UTC+5:30, Mandeep Baluja wrote: > > Hi SG, > > Things I would like to know !!! > 1) What is required You need formula in column "I" or You need to > distribute data in "K3:P5" > 2) Why headers(%) B:H and k:P are different? are they being used in > formulas for calculation. > 3) What is final Score ? > > Can we have the result set below your question with result required > manually for better understanding. > > 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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Need Help in calculation of score
> > 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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. SG (2).xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Need Help in calculation of score
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 =IF(H3="No",0 > > 2)If any parameter is "No", then its score should get deducted from final > score formula should be IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3) > Now on combining these two formulas > is =IF(H3="No",0,IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3) > > Confusion !! > 3) if any of parameter is NA then its score must be distributed in rest > of the parameters.(Not to M(Fatal) parameter) > *Score must be distributed in rest of parameters ??? Does it mean > formula should do distribution on which cells ? because k3:p5 is already > filled with your formula.Can you put the output manually below your data.* > > *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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1 - Copy.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Need Help in calculation of score
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:-
1) What i need is to calculate the final score in column "I"
2) however, i'm, not able to do distribution of score. "Here the
distribution is given in range("K3:P5")"
3) if any of parameter is NA then its score must be distributed in rest of
the parameters.(Not to M(Fatal) parameter)
4) Sorry for the confusion. Final score is 100 if all are Yes.
5) I need the formula in Colum "I" for Score.(Distribution of Score in case
of "NA" should be calculated here.)
6) The difference in headers are typo errors.
7) d4 & e4 are no..that means their score 30& 10 = 40 gets divided by 4. so
the score in k4 is 20,l4=30,m4=0,n4=0,o4 =25 & p4=25,*so that final score
in i4 is 100. if any parameter goes "No"*, then its number get deducted
from total score.
8) Also, in k11, why the score is 20. It should be 10 only according to the
header & same for rest of the cells.
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. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
