Results 1 to 2 of 2

Thread: Excel - If Formula Query

  1. #1
    Neophyte usmanhussain13's Avatar
    Join Date
    Jan 2019
    Posts
    3
    Articles
    0
    Excel Version
    2010

    Excel - If Formula Query



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    Im having some issues with the IF formula.

    Basically i'm comparing two cells, Say L2 and L3. Lets say column header L1 is socks colour. L2 is Red and L3 is Green, my If formula in M1 i want to A) identify if there is a difference, B) what the different was. So i would want it to say Sock Change from Green to Red. Im trying an If Formula, i know how to make it compare the cells and derive a text and say for instance "no change" or "Colour changed" but i cant get it to say Colour changed by bringing back the value of L2 and L3 to say Sock colour changed from Red to Green. Appreciate any help.

    Thanks,
    U.H

  2. #2
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    79
    Articles
    0
    Excel Version
    2013
    Maybe something like
    =IF(L2<>L3,"colour changed from "&L2&" to "&L3,"No change")

Tags for this Thread

Posting Permissions

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