Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
MAKING A FORMULA FOR CHANGING AMOUNTS | Excel Discussion (Misc queries) |