if(b2=1,b3,0) is this correct

[boschcac]

Many years ago, i created a spreadsheet with Lotus with 26 columns, one for
each income or expense, I used a boolean if formula, but forget how to do it.
Help?
Only positive answers please. Nothing fancy!.

 

[Bob Phillips]

=IF(AND(B2=1,B3-0),"Correct","Not")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Biff]

Hi!

if(b2=1,b3,0) is this correct

Yes, the syntax is correct.

Here's what it means:

The cell in which this formula resides will return the
value from cell B3 if the value in cell B2 equals 1,
otherwise, it will return 0.

Biff