Nesting multiple IF formulas

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?

Try
=IF(M410="","OWNED",IF(M410>$P$1,"CURRENT","EXPIRED"))

Maybe

=IF(LEN(M410)=0,"OWNED",IF(M410 > $P$1,"CURRENT","EXPIRED"))

Maybe change "OWNED" to the cell with contains the choices

=IF(LEN(M410)=0,A1,IF(M410 > $P$1,"CURRENT","EXPIRED"))

That didn't work either. Okay....so here is what I have to work with:
Column O=Leased, Owned, Rented, Rental/Flex Fleet
Column M=Lease End Date
Column P=Current, Expired, Owned, Rental or Rental/Flex Fleet

I need to first look at Column O to determine what the equipment is. If Owned, Rented or Rental/Flex Fleet I need Column P to say Owned, Rented or Rental/Flex Fleet. If it is Leased then I need it to look at Column M to see if the date is already passed or if it is a future date. If it is in the past then Column P needs to say Expired. If it is a future date then Column P needs to say Current. This formula DOES work =IF(M410>$P$1,"CURRENT","EXPIRED") so I just need to know how to incorporate the rest. ($P$1 is the cell with my current date.)



Does this help?

It would help better to see a mocked up workbook with the results you desire.

In this sample about 5 rows would be good with the results and then we can work in the formula from there.

What about...

=IF(OR(O3={"Owned","Rental","Rental/Flex Fleet"}),O3,IF(AND(O3="Leased",M3>$P$1),"CURRENT","EXPIRED"))