Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If\then statements in Excel
I am manually scrolling through Excel right now to find all blank
cells in column L. Some cells have dates, others are blank. IF L is BLANK, I go to row K and copy/paste row K to row L. IF K is BLANK, I got to row I and copy/paste to row L. Basically, I need dates in row L to run this report accurately. The order goes: 1. L 2. K 3. I Where L is populated I leave it alone, if L is blank I populate it with K, if K is blank I populate it with I. Is there a statement I can put into row L to basically say "If blank copy/paste from row K. If row L and K are blank go to row I and copy/ paste to L." ??? This would make life easier! Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If\then statements in Excel
Assume your data starts on row 1 - enter this in L1:
=IF(L1<"",L1,IF(K1<"",K1,I1)) and copy down column L for as many rows as you need. Hope this helps. Pete On Oct 24, 5:52 pm, wrote: I am manually scrolling through Excel right now to find all blank cells in column L. Some cells have dates, others are blank. IF L is BLANK, I go to row K and copy/paste row K to row L. IF K is BLANK, I got to row I and copy/paste to row L. Basically, I need dates in row L to run this report accurately. The order goes: 1. L 2. K 3. I Where L is populated I leave it alone, if L is blank I populate it with K, if K is blank I populate it with I. Is there a statement I can put into row L to basically say "If blank copy/paste from row K. If row L and K are blank go to row I and copy/ paste to L." ??? This would make life easier! Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
Excel - Any Help On If Statements | Excel Discussion (Misc queries) | |||
Excel If Statements, please help! | Excel Worksheet Functions | |||
Excel Help with IF statements | Excel Discussion (Misc queries) | |||
Nesting more than nine IF statements in Excel | Excel Worksheet Functions |