In B1 enter

=IF(A1=0,1,"A1 not 0 or blank")


Gord Dibben MS Excel MVP

On Wed, 27 Dec 2006 13:11:00 -0800, karensa
wrote:

I want to make the following...If A1=0 then B1=1. I simply have not
understood the help sections on this, so would someone just make it simple
for me. Thanks