In B1, insert the formula =IF(A1=0,1,""), assuming that you want B1 to be
blank if A1 is not zero. If you want B1 to be something else in that case,
then put the something else instead of the "".
--
David Biddulph

"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