in cell B1 place
=IF(A1=0,1,"")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"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