I have the following data:

2004BAL 2005ACT 2006ACT
50000 0 10000
0 5000 0
10000 0 10000
5000 4000 0
0 5000 0
0 0 5000
15000 0 0
12000 0 0

I need an IF function that says
IF 2005 ACT = 0 AND 2006 ACT = 0 THEN 2004 BAL, ELSE NULL. The result
in the first six rows would be null, in the seventh row, it would be
15000 and in the eighth row it would be 12000.

I don't know how to put that into an Excel IF function.

Thank you for your help.

If your data starts in A2:C2, try
=IF(OR(B2:C2),"",A2)
and copy down.

Using AND:
=IF(AND(B2=0, C2=0), A2, "")


"buffgirl71" wrote:

I have the following data:

2004BAL 2005ACT 2006ACT
50000 0 10000
0 5000 0
10000 0 10000
5000 4000 0
0 5000 0
0 0 5000
15000 0 0
12000 0 0

I need an IF function that says
IF 2005 ACT = 0 AND 2006 ACT = 0 THEN 2004 BAL, ELSE NULL. The result
in the first six rows would be null, in the seventh row, it would be
15000 and in the eighth row it would be 12000.

I don't know how to put that into an Excel IF function.

Thank you for your help.