If Greater then this Value "Due" unless a date is entered (If Formula or logical expression)

None RBT

Looking for the best way to calculate this. I'm using temporarily conditional formatting to make past "due" as "red".

This form is tracking probationary employees. Logically I haven't figured out how to do this. So when the estimated completed hours is greater then 160 then their 160 evaluation is "past due", unless there is a date in the field. (if a date it means it was completed on that date)

Same thing for each level.

When the [estimated completed hours] is greater then 320 then their [320 evaluation] is "past due", unless there is a date in the field.

When the [estimated completed hours] is greater then 480 then their [480 evaluation] is "past due", unless there is a date in the field.

so on and so on

Thanks in advance

Paul Newcome

If you are trying to populate "Due" into the columns, then it would go something like this...

=IF([Estimated # of Hours Completed]@row > 160, "Due")

The above would go into the [160 Evaluation] column. Just update 160 to the appropriate number for each of the different columns.