Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help on formula
I need to transfer datas from cells K11 and L11 to AE11 and AF11 based on
the answer of P11. For example if P11 is Y then the data from K11 & L11 will transfer to AE11 & AF11, but when P11 is N, then the data would not transfer. How do I create a formula for that? |
#2
|
|||
|
|||
=IF(P11="Y",K11,"") Enter this in AE11. Enter this in AF11
=IF(P11="Y",L11,"") The "" at the end tells Excel to put a space in the cell if the condition is not met. Hope this helps, Carole O "sari pratiwi via OfficeKB.com" wrote: I need to transfer datas from cells K11 and L11 to AE11 and AF11 based on the answer of P11. For example if P11 is Y then the data from K11 & L11 will transfer to AE11 & AF11, but when P11 is N, then the data would not transfer. How do I create a formula for that? |
#3
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Help with array formula | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |