Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested Sub-Totals in Excel | Excel Discussion (Misc queries) | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |