|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