copying formula down

B

BK

Using Excel 2003

Column A is dates. These dates plus 7 are being compared to the current
date to determine whether "overdue" gets displayed in Column D. I'm using
the following IF statement:

If A1+7<today(),"overdue"," "

When I copy the formula down, rows that have not yet had data entered into
them are all displaying "overdue" because Column A is blank. Do I just need
to remember to copy the formula down every time I enter a new row of data,
or is there some way I can modify my IF statement to only do the calculation
if there is data in Column A?
 
M

Max

Try instead in B1: =IF(A1="","",IF(A1+7<TODAY(),"overdue",""))
Copy down as far as required.
The additional front trap: =IF(A1="","",... will take care of the problem.
 
K

Ken Wright

If you are using 2003 then as long as you have in Tools / Options / Edit /
Checked the 'Extend data range and formulas' option, the formulas should
automatically be added when you put in data anyway, BUT, personally I like
belt and braces, so i'd still be there with Max and Otto :)
 
B

BK

Of course!! I'm just getting used to nested IF statements, and I forgot all
about it.

Thanks!!
 
B

BK

Didn't know about that option in 2003, but I've already changed to the
nested IF statements. Thanks so much for the information.
 
K

Ken Wright

You're welcome :)

BK said:
Didn't know about that option in 2003, but I've already changed to the
nested IF statements. Thanks so much for the information.
Click to expand...
 
Top