Put this in cell B1:

=IF(A1=1,"Y","")

This only works if you want column B's cells to be blank if the valu
in column A is "1". Otherwise you'll have to ammend the formula lik
this:

=IF(A1=1,"Y","N")

- Piku

--
Message posted from http://www.ExcelForum.com