+ Reply to Thread
Results 1 to 6 of 6

How to use an if statement to show a name in a cell

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    18

    How to use an if statement to show a name in a cell

    I am trying to use the if statement, if a cell = a cell that has a word in it then show content of another cell that has a name in it.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to use an if statement to show a name in a cell

    the IF() statement compares values of the cells so

    Please Login or Register  to view this content.
    will compare the contents of A3 and b3 and if there is a match display the content of c3 else display nothing

  3. #3
    Registered User
    Join Date
    02-04-2014
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: How to use an if statement to show a name in a cell

    I must not have explained this very well sorry. Here is what have i have one cell that states =IF(D5<TODAY()-365,"needed","") Now i need a statement to indicate that if that cell has needed in it then i need it to print the name that is in a5

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to use an if statement to show a name in a cell

    OK the best way to help send a non sensitive sample with the expected output in an excel sheet

  5. #5
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    960

    Re: How to use an if statement to show a name in a cell

    Assuming the name you want to show is in cell A5, and your sample formula above is in cell E5 a formula like this would work: =IF(E5="needed",A5,"")

  6. #6
    Registered User
    Join Date
    02-04-2014
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: How to use an if statement to show a name in a cell

    That worked
    Thank You

+ 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. Force IF statement to show on new line (ALT+ENTER) in cell
    By lukestkd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 07:54 PM
  2. needing to add if less than zero, show as zero to an IF statement thread
    By sarawhitt in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-04-2012, 07:33 AM
  3. Adjust IF statement to not show Zero's
    By WeedMan in forum Excel General
    Replies: 6
    Last Post: 08-29-2011, 06:35 PM
  4. If statement Don't Show Data if cell is empty
    By PacE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2008, 04:57 PM
  5. IF statement to show legend
    By Turnipboy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-24-2007, 06:47 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