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

[[email protected]]

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)


"[email protected]" <[email protected]@discussions.microsoft.com> wrote in
message news:[email protected]...
> 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!.

[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

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