Use an IF statement, as such:

=IF(A1="Y",10,IF(A1="N",5,""))

Place this formula in the cell of your choice (other than A1, of
course)

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397745