Use cell formatting (e.g. "Good", "Bad", "Neutral") in formulas?

Posted by ngm on Super User See other posts from Super User or by ngm
Published on 2010-05-11T11:36:10Z Indexed on 2010/05/11 11:44 UTC
Read the original article Hit count: 190

Filed under:
|
|
|

I am compiling a comparison of different pieces of software in an Excel spreadsheet. It is a big long list of features (the rows), with each column being one of the applications I'm evaluating. I've used styles to visually show how well each product meets each feature, as well as the importance of that feature, and now I'm wondering if there's a way I can use those annotations in a formula.

The table is like:

.         | Product A | Product B | Product C
Feature A |   blah        blah        blah
Feature B |   blah        blah        blah
Feature C |   blah        blah        blah
....      |
....      |
etc       |

Where I've put 'blah' in the table above, in my actual spreadsheet is (potentially lengthy) descriptive text explaining something about this feature in the given product.

I've then used the styles "Good", "Neutral" and "Bad" to visually annotate the description, to show how well each product meets that feature.

For each feature I've also used the styles Accent4, 60% Accent4, 40% Accent4, etc, to annotate the importance of each feature.

Now I'm wondering if somehow I can use those styles (the annotations) to tot up a total score for each product.

e.g., Score for feature A = valueof(60% Accent4) * valueof(Good)

Is it possible at all?

© Super User or respective owner

Related posts about excel-2007

Related posts about excel