LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
making a formula that will display a "word" in multile cells xspacex Excel Worksheet Functions 1 July 30th 06 02:14 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
MAKING A FORMULA FOR CHANGING AMOUNTS BRUCE Excel Discussion (Misc queries) 2 December 2nd 05 07:45 PM


All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"