you won't be able to add an 8th choice using IF!

Look in Help for VLookup.

Maybe like this:

In cell A1: enter the number 1
Cell A2: 2
Cell A3: 3


In the corresponding rows in the B col, enter the formulas

Now you have made the lookup table aka table_array.

If the choice they make is in cell A8, the formula will look like
this:

=VLOOKUP(A8,A1:B3,2,FALSE)


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=475052