How do I write this formula
 

Hi I am trying to write a formula that has a few criteria and results.

I need a formula in cell K7 (2005): if cell D6 = "Off" and E6 = "2005" to
return a value of "0", but if cell D6 = "On" and E6 = "2005" the value from
the cell K7 (one other tab in workbook).

To complicate, in cell in cell J7 (2004): if cell D6 = "Off" and E6 =
"2005" to return the value from the cell J7 (one other tab in workbook), but
if cell D6 = "On" and E6 = "2005" the value from the cell J7 (one other tab
in workbook).

A D E J K L
Row 6 500105 OFF/ON 2005 2004 2005 2006
Row 7 formula formula formula

How do I write this formula
 

that could just be a nested if:

=IF(AND(D6="Off",E6=2005),0,IF(AND(D6="On",E6=2005 ),K7,IF(AND(D6="Off",E6=2005),J7,IF(AND(D6="On",E6 =2005),J7))))

Although, I think one of these should be L7, not sure which.

"Jill_" wrote:

Hi I am trying to write a formula that has a few criteria and results.

I need a formula in cell K7 (2005): if cell D6 = "Off" and E6 = "2005" to
return a value of "0", but if cell D6 = "On" and E6 = "2005" the value from
the cell K7 (one other tab in workbook).

To complicate, in cell in cell J7 (2004): if cell D6 = "Off" and E6 =
"2005" to return the value from the cell J7 (one other tab in workbook), but
if cell D6 = "On" and E6 = "2005" the value from the cell J7 (one other tab
in workbook).

A D E J K L
Row 6 500105 OFF/ON 2005 2004 2005 2006
Row 7 formula formula formula