Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: If cell equals X return value from other cell

  1. #1
    Join Date
    12th July 2010
    Posts
    2

    If cell equals X return value from other cell

    I am trying to establish a formula, but not too sure how.

    For example " If Cell A5 has been marked with ' X ', then copy what is in Cell A6 to

    cell C25 "
    Last edited by AAE; July 12th, 2010 at 20:10. Reason: Amend thread title

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,653

    Re: Copy If Formula Help please

    Is it?
    C25 =IF(A5="X",A6,"")
    Triumph without peril brings no glory: Just try

  3. #3
    Join Date
    12th July 2010
    Posts
    2

    Re: Copy If Formula Help please

    That formula when I enter it, it stays as a text, not too sure why?

    Also please:
    What if I need to copy text or numbers from a range of cells to one cell. Is this possible?
    " If Cell A5 to A10 has been marked with ' X ', then copy what is in Cell A6 to A10
    into cell C25 "
    Last edited by AAE; July 13th, 2010 at 03:58. Reason: delete unnecessary quote

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,653

    Re: If cell equals X return value from other cell

    Can you give more detail and perhaps send an example of your file.
    If A5=A6=...A10 = X

    C25 = XXXXXXXXX
    ????
    Triumph without peril brings no glory: Just try

  5. #5
    Join Date
    19th January 2005
    Location
    Michigan, USA
    Posts
    844

    Re: If cell equals X return value from other cell

    Just to rule this out since you said that the formula stays as text. You did put this first one into cell C25:

    =IF(A5="X",A6,"")
    versus:

    C25 =IF(A5="X",A6,"")

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 3
    Last Post: June 24th, 2008, 15:38
  2. Replies: 3
    Last Post: September 13th, 2007, 21:21
  3. Error when copy or formula copy
    By lindali in forum EXCEL HELP
    Replies: 13
    Last Post: December 13th, 2005, 05:05
  4. copy formula
    By pbdsp in forum EXCEL HELP
    Replies: 3
    Last Post: October 11th, 2005, 20:34
  5. Copy Formula
    By Smudger in forum EXCEL HELP
    Replies: 16
    Last Post: November 5th, 2004, 17:30

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