If\then statements in Excel

H

hondacivicex92

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

Pete_UK

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
 
Top