vendredi 26 juin 2015

Excel Model based on Qualitative variables

I am wanting to build a model for each company that if they have a certain parameter then i will give them a value. Effectively, it is ranking a company based on variables from most important to least important.

=IF(C2=1,$B$2,0)

I would like to put a company name and do 1s and 0s only and then have it give me a total and then put chart it.

How would I do this in a compact way?

http://ift.tt/1BSL8da

Aucun commentaire:

Enregistrer un commentaire