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.
|