If Statement - Basic

Portuga · Jan 23, 2006

Bit of basic question.

If A1 = 0 then B1=No, else B1=Yes

How can I do this using an if statement?

Thanks

Guest · Jan 23, 2006

Hi

In B1 type
=IF(A1=0,"No","Yes")

Andy.

Bob Phillips · Jan 23, 2006

In B1 enter =IF(A1,"Yes","No")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)