Solved Excel 2010: IF/AND nested function w/ a date

November 25, 2011 at 10:48:03
Specs: Windows 7
Hello there, I have been looking a while now without much luck. It may be that I don't quite know the proper search terms but my problem is this:

the problem concerns apartments, their occupancy, and their last remodel.
I am looking to create a nested function that will return "Need To Remodel" as the result if 'F14' is is unoccupied and was last remodeled before 2005 ('G14'). Otherwise, the function should return "No Change" as the result.

Column F has yes/no values concerning whether it is occupied
Column G has a date (2004,2008,2001, etc) giving its last remodel

Any help would be greatly appreciated

See More: Excel 2010: IF/AND nested function w/ a date

Report •

November 25, 2011 at 11:01:05
✔ Best Answer
re: Column G has a date (2004,2008,2001, etc)

2004, 2008, 2001 are not dates. If that is all that is in the cell, it's just a number according to Excel.

=IF(AND(F14="No", G14<2005), "Need To Remodel", "No Change")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

November 25, 2011 at 11:10:58
Thanks for the quick reply!

The result from your formula gives me False. I switched it around to..

=IF(AND(F14="Yes",G14<2005), "No Change","Need To Remodel"

The value this gave was no change, which is correct for that input. However it doesn't copy down to other entries properly. It seems to be ignoring the before/after 2005 constraint, only focusing on the yes/no criteria. Any thoughts?

Report •

November 25, 2011 at 11:58:55
It works, depending on what your looking for:

F14="No" it is not occupied

F14="Yes" it is unoccupied


Report •

Related Solutions

November 25, 2011 at 12:16:36
I guess I misinterpreted what the question was asking me to find in the first place. Both functions work as you point out mmcconaghy, the function that my question is asking me to solve requires the F14="Yes". Thanks both of you :)

Report •

March 22, 2012 at 13:00:18
Hey Mike I was wondering if you could possibly help me with creating a nested function also? Thanks!!

Report •

March 22, 2012 at 16:56:52

Ask your question in a new thread, it impolite to hijack another persons question.

And unless you really enjoy getting a lot of spam, I would edit out my email address.
It is not a wise thing to post your email address on a public forum.


Report •

March 22, 2012 at 17:56:40
Well excuse me, I don't fully understand the "forum code", mainly because I have never actually used them until today and I ran across this forum for what I was looking for. Thanks but no thanks I will find my much needed assistance elsewhere!

Report •

March 22, 2012 at 18:30:30
Thanks but no thanks I will find my much needed assistance elsewhere!

Not sure what you took offense to, as I was simply trying to enlighten you as to the proper etiquette used on this forum.

If you have a question, simply ask it in a thread that you have started.
Many people do not bother with old discussions, but will take a look at
any new questions that appear, so you have a better chance of getting an
answer if you start a new line of inquiry instead of tacking your question onto the
tail end of another thread.

I am glad to see you removed your email address.


Report •

Ask Question