+ Reply to Thread
Results 1 to 7 of 7

If Cells Match Then enter Text

  1. #1
    Registered User
    Join Date
    06-07-2014
    Posts
    3

    If Cells Match Then enter Text

    Hello,

    Is it possible to add a formula in a blank cell to do the following...

    Example:

    Look at cells C4, D4 and F4, if the dollar amounts match for all 3 cells enter "Balanced" in cell G4
    Look at cells C4, D4 and F4, if the dollar amounts does not match for all 3 cells enter "Not Balanced" in cell G4

    Please note all 3 cells need to equal each other, if 1 out of 3 cells do not match I would like G4 to show "Not Balanced"

    Thank you!

  2. #2
    Registered User
    Join Date
    05-02-2014
    Location
    Portage, Indiana
    MS-Off Ver
    Office 2010
    Posts
    27

    Re: If Cells Match Then enter Text

    Try this:
    =IF((C4=D4)*(AND(D4=F4)),"Balanced","Not Balanced")
    I hope this helps.

    Bruce
    Last edited by Madmaxneo; 06-07-2014 at 11:26 PM.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: If Cells Match Then enter Text

    Try this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    06-07-2014
    Posts
    3

    Re: If Cells Match Then enter Text

    Thank you so much Madmaxneo and sktneer both formulas worked for me!

    I appreciate your help and time.

    Can I ask another questions please?

    Is it possible to do the following...

    If C4 = 2 and D4 = 2 and F4 = 1; can I have H4 = 1 (The difference between C4/D4 and F4)
    If C4 = 2 and D4 = 1 and F4 = 2; can I have H4 = 1 (The difference between C4/F4 and D4)
    If C4 = 1 and D4 = 2 and F4 = 2; can I have H4 = -1 (The difference between C4 and D4/F4)

    I would like H4 to reflect the difference amount if C4, D4 and F4 do not equal?

    I hope you can help me again...thanks so much!

    Paula

  5. #5
    Registered User
    Join Date
    05-02-2014
    Location
    Portage, Indiana
    MS-Off Ver
    Office 2010
    Posts
    27

    Re: If Cells Match Then enter Text

    Thank you. They were basically the same formula, though sktneer's was cleaner.
    The new formula sounds like a math problem, if your good at math and then all you need to do is figure out how to get the answer. Converting it to a formula is easy, basically put an equal (=) sign at the beginning. I will look and see if I can figure it out in the meantime.
    I'm not sure if your supposed to click on add reputation or not, but you could do it for both of us if you prefer.
    Bruce

  6. #6
    Registered User
    Join Date
    05-02-2014
    Location
    Portage, Indiana
    MS-Off Ver
    Office 2010
    Posts
    27

    Re: If Cells Match Then enter Text

    Got it! I think, not sure if this is what your looking for but it works and gives the results in the example you gave. I hope it helps.

    Please Login or Register  to view this content.
    Now I think this will only work if there are only two different values in the three cells, if there are more values it might not work for what you want.

    Bruce
    Last edited by Madmaxneo; 06-08-2014 at 06:08 PM.

  7. #7
    Registered User
    Join Date
    06-07-2014
    Posts
    3

    Re: If Cells Match Then enter Text

    That's it! Thank you Bruce, your a gem!

    Thanks again for all your help and take care.

    Paula

+ 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. [SOLVED] Match text then enter formula
    By ChrisXcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2014, 08:09 PM
  2. Replies: 3
    Last Post: 09-20-2013, 04:24 PM
  3. [SOLVED] How can i match values from 4 cells then enter value from a 5th cell?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2013, 10:17 AM
  4. Match text in A1 to a part of a text string in B1 and enter data D1
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 10:16 PM
  5. Replies: 3
    Last Post: 06-02-2011, 11:03 AM

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