View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mick Mick is offline
external usenet poster
 
Posts: 23
Default Making too much of a formula

I started off with a simple formula but am I making too much of it?

I wanted a cell (Y38) to give the status of the record based on the date in
cell W38.
If there was no date in X38 (date a letter was sent) then I would either get
an 'overdue' message or a 'complete' message depending on the date in W38

W= date due
X = date sent
Y = status

=IF(TODAY()<=W38,"",IF(AND(TODAY()W38,X38=""),"Ov erdue","Complete"))

This worked fine, but I noticed if the letter was sent early (add a date to
cell X38) the status cell would remain blank and today's date had passed.

So I thought the following might work.
=IF(X38<"","Complete",IF(TODAY()<=W38,"",IF(AND(T ODAY()W38,X38=""),"Overdue","Complete")))

It does work, but Excel is telling me the formula is inconsistent, does this
matter, am I over complicating things?

Appreciate any feedback.
Thanks
Mick