I have 22 options. Instead of using the IF function what can I use or
can I use the IF function w/ another function? This is what I have.

Cells A1, A2, A3 and so on

This is what I started w/ the IF function:

=IF(A1=0,22,IF(A2=0,21,IF(A3=0,20 and so on

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700