+ Reply to Thread
Results 1 to 3 of 3

Need Final Value to be Based on Data in 2 Other Cells

  1. #1
    Registered User
    Join Date
    02-19-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2013
    Posts
    69

    Need Final Value to be Based on Data in 2 Other Cells

    I have a formula that works out how many days it is until an employee's 2015 anniversary date, once it passes that date it becomes negative. When it becomes 0 or negative, it changes to "Congratulations!!".

    BUT when I have a new employee, because we're looking at 2015 anniversaries and since they were hired in 2015, they immediately become "congratulations".

    I added a column and wrote =IF(A2<365, "new", "old") and thought maybe if I could find a formula that requires both column A to be negative and column B to be "old" for it to show "Congratulations" or if they were Colum A negative and Column B "new" I could show "Welcome".

    I hope that makes sense.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,076

    Re: Need Final Value to be Based on Data in 2 Other Cells

    What's your current formula?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    632

    Re: Need Final Value to be Based on Data in 2 Other Cells

    Try this:

    =IF(A2="","",IF(AND(A2<=0,B2="Old"),"Congratulations!!",IF(AND(A2<365,B2="New"),"Welcome")))
    If I've helped U pls click on d *Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Final Estimate Form and a Final Materials List based on Worksheet Results
    By Crunched For Time in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-20-2013, 09:58 PM
  2. Extract Rows based on cell value into final sheet.
    By gcf81 in forum Excel General
    Replies: 0
    Last Post: 08-07-2012, 12:01 PM
  3. replacing lowest test grade with final if final is higher formula help
    By colbyclay in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2012, 02:48 AM
  4. Final tab based on checkboxes
    By billh0918 in forum Excel General
    Replies: 0
    Last Post: 01-20-2012, 11:54 AM
  5. Replies: 4
    Last Post: 07-15-2011, 02:01 PM

Tags for this Thread

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