+ Reply to Thread
Results 1 to 4 of 4

IF function to see change between two cells

  1. 05-21-2020, 07:29 AM #1
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    IF function to see change between two cells

    Hi guys

    Can anyone please advise how I can differentiate betweeen two cells..

    I have attached my sheet basically in cell A2 and B2 I want to see if there is a change between A2 and B2 that C3 should show 'change'

    thank you
    Attached Files Attached Files
    Thanks,

    R.


    Reply With QuoteRegister To Reply
  2. 05-21-2020, 07:38 AM #2
    Eastw00d
    Eastw00d is offline
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: IF function to see change between two cells

    Hi, copy this down from C2:
    Please Login or Register  to view this content.
    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...
    Reply With QuoteRegister To Reply
  3. 05-21-2020, 07:40 AM #3
    ORoos
    ORoos is offline
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: IF function to see change between two cells

    Hi Rayted,

    If the changes are case sensitive (R vs r = change) try: =IF(EXACT(A2,B2)=TRUE,"Same","Change")
    if not case sensitive try: =IF(A2=B2,"Same","Change")
    Reply With QuoteRegister To Reply
  4. 05-21-2020, 12:57 PM #4
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: IF function to see change between two cells

    thanks guys, rep added!
    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. IF Function to change color of cells
    By npucci in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2016, 01:59 PM
  2. Using the IF function to change multiple cells
    By ShaunCIT in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-12-2014, 11:06 PM
  3. How to change empty cells to blank cells (need to use skip blanks function)
    By ChristopherH in forum Excel General
    Replies: 4
    Last Post: 03-08-2014, 02:03 PM
  4. VBA to erase cells and change function
    By nup21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2012, 01:52 AM
  5. Need Sum function to change cells each day
    By Daire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2012, 05:14 PM
  6. [SOLVED] Change cells inside a function
    By in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 08:35 AM
  7. How can I change the colour of cells using an IF function?
    By gctexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2005, 09:06 AM

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