Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: If Cell Equals Text Then Return Another Cell

  1. #1
    Join Date
    21st August 2008
    Posts
    2

    If Cell Equals Text Then Return Another Cell

    I need a formula that If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell...


    at the mo i've got

    =IF(A2="PAID OUT", "OK", "Not OK")

    but instead of the cell reading OK or Not OK, i need it to equal another cell. ie, if A2="PAID OUT", then =B2



    how do i do that?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th June 2007
    Posts
    70

    Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

    Hi,

    =IF(A2="PAID OUT", B2, "Not OK")

    Eric

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    23rd April 2008
    Location
    Work in North Wales
    Posts
    262

    Re: If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell?!

    and cue Dave...

    ;-)

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 8
    Last Post: June 12th, 2008, 02:05
  2. Flag When Cell Equals a Value
    By Dean1987 in forum EXCEL HELP
    Replies: 10
    Last Post: May 20th, 2007, 18:52
  3. Delete Row If Cell Equals
    By Diego Garcia in forum EXCEL HELP
    Replies: 2
    Last Post: March 12th, 2007, 02:54
  4. Active Cell equals far left cell when macro starts
    By GuyGadois in forum EXCEL HELP
    Replies: 2
    Last Post: July 26th, 2006, 07:19
  5. Replies: 6
    Last Post: May 13th, 2005, 23:04

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
  •  
porno