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: 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

What would this score? Doesn't Meet

Doesn't Meet

Meets

MeetsAnd this?

Doesn't Meet

Mostly Meets

Mostly Meets

MeetsOnce other question: Are all factors weighted equally?

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

Ask Your Question

Weekly Poll