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

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!.

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

--

HTH

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


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

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

-----Original Message-----
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!.
.