copying formula down

  • Thread starter Thread starter BK
  • Start date Start date
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?
 
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.
 
BK
Try this:
=IF(A1="","",IF(A1+7<TODAY(),"overdue","OK"))

HTH Otto
 
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 :-)
 
Of course!! I'm just getting used to nested IF statements, and I forgot all
about it.

Thanks!!
 
Didn't know about that option in 2003, but I've already changed to the
nested IF statements. Thanks so much for the information.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel due and overdue date colours 2
conditional format in a row 3
Excel Help to copy information from one row at a time to another sheet 1
Countifs with "or" embedded? 1
Sorting based on IF statement *please help me!* 1
Not sure what I need other than help 4
macro for displaying conditional formatting 1
Quick VBA Worksheet Change Event or Selection Question: 1

Back
Top