Announcement

Collapse
No announcement yet.

If cell equals X return value from other cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 20:10. Reason: Amend thread title

  • #2
    Re: Copy If Formula Help please

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

    Comment


    • #3
      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, 03:58. Reason: delete unnecessary quote

      Comment


      • #4
        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

        Comment


        • #5
          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,"")

          Comment

          Working...
          X