Results 1 to 17 of 17

Nesting multiple IF formulas

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    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?

    Last edited by tiffany04530; 09-14-2012 at 10:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1