Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign number to every value in a data range???
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Match and Sort two range of data? | New Users to Excel | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |