# Excel Formula - Calculator

February 11, 2011 at 08:14:11
Specs: Windows 7
 Hi,I need to work out an overall score based on four factors. The overall score then needs to be presented in 3 options. For exampleEXAMPLE 1:Factor 1: Doesn't MeetFactor 2: Doesn't MeetFactor 3: Doesn't MeetFactor 4: Doesn't MeetOverall Score: Doesn't MeetExample 2:Factor 1: Doesn't MeetFactor 2: Mostly MeetsFactor 3: Doesn't MeetFactor 4: Mostly MeetsOverall Score: Mostly MeetsExample 3:Factor 1: MeetsFactor 2: Doesn't MeetFactor 3: MeetsFactor 4: MeetsOverall Score: MeetsIs there a way I can have a formula that works out the possible varientions for each factor and then calculates the overal score?? Sounds tricky but I'm sure it's possible.Please let me know.Cheers

See More: Excel Formula - Calculator

#1
February 11, 2011 at 08:58:47
 What would this score?Doesn't MeetDoesn't MeetMeetsMeetsAnd this?Doesn't MeetMostly MeetsMostly MeetsMeetsOnce other question: Are all factors weighted equally?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions