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