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.
