Complicated IF formula

  • Thread starter Thread starter ml8889
  • Start date Start date
M

ml8889

I want to create a formula that looks for results in 2 columns before it
returns it's value.

For instance:

I am tracking the process of projects.

In the cells of column B, I have this formula:

=IF(D1="","Set Goal Date",IF(D1=TODAY(),"Due
Now",IF(D1<TODAY(),"OVERDUE",IF(D1<TODAY()+10,"Review
Soon",IF(D1>TODAY()+9,"OK")))))

In column D, we are recording our Goal Completion date of the project.
What the formula in column B will do is help us determine how close we
are to the projected deadline, whether we're ok, need to review soon,
overdue, etc.

In column E, we are recording the Actual Completion date of the
project.

What I want the formula to do in column B is, for instance, look at E1
and if a date has not been entered there, then perform the formula on
D1. If a date has been recorded in the E1 cell, then I want the
formula to return the value, "Complete".

How can I make this happen? How can I make my IF formula work between
the 2 columns?

Thank you to anyone who can help me crack this.
 
ml8889 said:
What I want the formula to do in column B is, for instance, look at E1
and if a date has not been entered there, then perform the formula on
D1. If a date has been recorded in the E1 cell, then I want the
formula to return the value, "Complete".

How can I make this happen? How can I make my IF formula work between
the 2 columns?
Click to expand...

Try this in cell B1:

=IF(ISBLANK(E1),<insert your function here>,"Complete")

Dave
dvt at psu dot edu
 
Back
Top