Hi guys
I'm building a sheet in where I want to store data about some web-sites
we surf in the net and could be interest for my company. So I insert a
serie of characteristic of the web-site in the colums (usability,
navigability, etc.) and in the rows an evaluation of every
characteristic from 1 to 9 . So people surf in internet and when they
find an interesting website they insert the info required to fill the
sheet. But then for every answer I would like to assign aother number
(if they say, for example, usability=1, I want assign to this value
another number, let's say 9) and see this number stored in another
sheet where then I can perform calculations. How can I do that? I tried
with =IF.. but I cannot perform that with more than 5 values...:
Thanks for your time!
The dude


--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=542551