In my spreadsheet I need to do the following:
1. If the lease end date is greater than today's date then the result will be CURRENT in the last column. If the lease end date is less than today's date then the end result will be EXPIRED. This is part 1 and my formula works fine.... =IF(M410>$P$1,"CURRENT","EXPIRED")
2. Part 2 is what I'm not sure about.... There are some that need to have a final result of OWNED, RENTED or RENTAL/FLEX FLEET. The rows with these choices have blank lease end dates. How do I make it look at the Leased/Owned column (which has the choices leased, owned, rented or rental/flex fleet) first to determine if it should then look at the Lease End Date column to determine if the result shoudl be CURRENT or EXPIRED?
![]()
Bookmarks