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 example

EXAMPLE 1:

Factor 1: Doesn't Meet
Factor 2: Doesn't Meet
Factor 3: Doesn't Meet
Factor 4: Doesn't Meet
Overall Score: Doesn't Meet

Example 2:

Factor 1: Doesn't Meet
Factor 2: Mostly Meets
Factor 3: Doesn't Meet
Factor 4: Mostly Meets
Overall Score: Mostly Meets

Example 3:

Factor 1: Meets
Factor 2: Doesn't Meet
Factor 3: Meets
Factor 4: Meets
Overall Score: Meets

Is 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

Report •

#1
February 11, 2011 at 08:58:47
What would this score?

Doesn't Meet
Doesn't Meet
Meets
Meets

And this?

Doesn't Meet
Mostly Meets
Mostly Meets
Meets

Once other question: Are all factors weighted equally?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question