+ Reply to Thread
Results 1 to 4 of 4

IF formula to show if two numbers equal, older or newer than each other - in seperate cell

  1. 08-19-2019, 10:02 AM #1
    Fionn Phelan
    Fionn Phelan is offline
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2202 (Build 14931.20858 Click-to-Run)
    Posts
    50

    Question IF formula to show if two numbers equal, older or newer than each other - in seperate cell

    If I have the number 2 in A1, and the number 3 in B1, I want C1 to show "Newer"

    If I have the number 3 in A1, and the number 2 in B1, I want C1 to show "Older"

    If I have the number 2 in A1, and the number 2 in B1, I want C1 to show "Same"


    Is there an easy way to work this?

    Reply With QuoteRegister To Reply
  2. 08-19-2019, 10:12 AM #2
    PaulM100
    PaulM100 is offline
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: IF formula to show if two numbers equal, older or newer than each other - in seperate

    try: =if(a1<B1,"Newer",if(a1>b1,"Older",if(A1=B1,"Same","")))
    Click the * to say thanks.
    Reply With QuoteRegister To Reply
  3. 08-19-2019, 10:20 AM #3
    Fionn Phelan
    Fionn Phelan is offline
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2202 (Build 14931.20858 Click-to-Run)
    Posts
    50

    Re: IF formula to show if two numbers equal, older or newer than each other - in seperate

    Solved & reputation added, thanks PaulM100.
    Reply With QuoteRegister To Reply
  4. 08-19-2019, 10:20 AM #4
    PaulM100
    PaulM100 is offline
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: IF formula to show if two numbers equal, older or newer than each other - in seperate

    glad to help and thank you for rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to show data if cell doesn't equal zero
    By heytherejem in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-31-2017, 01:22 PM
  2. Solution . . . Too Light Print On Older Spreadsheets With Newer Laser Printer
    By poolmon in forum Excel General
    Replies: 1
    Last Post: 03-30-2016, 05:45 PM
  3. [SOLVED] a formula to help seperate numbers?
    By gassiusmax in forum Excel General
    Replies: 6
    Last Post: 11-02-2014, 08:25 PM
  4. automatically convert older XLS versions to newer
    By Esmoreit in forum Excel General
    Replies: 11
    Last Post: 06-03-2009, 08:47 AM
  5. Show dates if multiple Serail numbers are equal
    By Dark_Templar in forum Excel General
    Replies: 6
    Last Post: 04-08-2006, 01:15 AM
  6. [SOLVED] SEPERATE NUMBERS IN A CELL
    By lehigh46 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-16-2005, 08:05 PM
  7. numbers being entered show in formula bar but not in cell?
    By Jim in Florida in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1