Karensa,

In B1, type the formula

=IF(A1=0,1, Value here that you want for when A1 doesn't equal 0)

Like, perhaps,

=IF(A1=0,1,0)

HTH,
Bernie
MS Excel MVP


"karensa" wrote in message
...
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