how can i get a multiple answers from one cell to another.

Example my output cell will be d6
if cell d5 says hello then d6 will say 100
if cell d5 says help then d6 will say 300
if cell d5 says test then d6 will say 500
if cell d5 says bye then d6 will say 700
etc..


i got one but its only for two answers, i need at least 20
=IF(A1="Pass",100,IF(A1="Fail",0,""))

Please help !!!!!!!


--
Moh
------------------------------------------------------------------------
Moh's Profile: http://www.excelforum.com/member.php...o&userid=35434
View this thread: http://www.excelforum.com/showthread...hreadid=552060