Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to Write a Formula | Excel Worksheet Functions | |||
How do I write this formula | Excel Discussion (Misc queries) | |||
How to write this formula? | Excel Discussion (Misc queries) | |||
how to write a formula | New Users to Excel | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) |