I apologize if this winds up being stupid-simple, but I have not used
Excel in quite some time and could not find an answer in tutorials or
on the web...

Is there a way to put a number in a cell, but have Excel calculate it
as a different quantity?

We are tabulating rankings of product: People chose their ten favorite
items and then were told them to rank them 1(highest)-10 (lowest).
We're assigning quantities to their rankings: #1=15, #2=14, etc. We
want to have their original rankings visible, but have the spreadsheet
calculate based on the quantities. Is there a way to enter a 1 and
have it calculate it as 15?

Thanks for whatever help you can offer,

hs


--
hos
------------------------------------------------------------------------
hos's Profile: http://www.excelforum.com/member.php...o&userid=30253
View this thread: http://www.excelforum.com/showthread...hreadid=499242