Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Nested IF/AND Statement

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Nested IF/AND Statement

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested Sub-Totals in Excel NC Yoko Excel Discussion (Misc queries) 5 October 4th 06 11:44 PM
Nested IF statement with VLOOKUP James Hamilton Excel Discussion (Misc queries) 1 August 16th 06 08:46 AM
Nested Subtotals in Excel 2002 KG Excel Discussion (Misc queries) 2 September 10th 05 12:51 PM
Why are my nested sub-totals are displaying incorrectly? chiefdean13 Excel Discussion (Misc queries) 1 July 20th 05 06:45 AM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 07:17 AM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"