+ Reply to Thread
Results 1 to 6 of 6

Formula not copying over to cell

  1. #1
    Registered User
    Join Date
    04-18-2018
    Location
    Maryland
    MS-Off Ver
    2016
    Posts
    25

    Formula not copying over to cell

    Hi Excel community,

    I am having an issue where my formula is not copying over to the other cells.
    example:

    I want the formula to say
    =IF((C9=AA1),1,0) however im getting =IF((C10=AA3),1,0). I want the formula to always say AA1. when I use the formula + to copy down the formula the rows do not change to the formula I want. does any one know what the issue may be?

    Thanks

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Formula not copying over to cell

    Like this:
    =IF(C9=$AA$1,1,0)

    You need to hardcode the AA1 cell

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Formula not copying over to cell

    Try
    =IF((C9=$AA$1),1,0)

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula not copying over to cell

    Meanwhile you do well to learn about relative/absolute cell referencing. This is fundamental for working with Excel.

    Here's one place that explains it.
    Dave

  5. #5
    Registered User
    Join Date
    04-18-2018
    Location
    Maryland
    MS-Off Ver
    2016
    Posts
    25

    Re: Formula not copying over to cell

    Thank you Everyone

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula not copying over to cell

    You are welcome. Thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Copying formula result to new cell, without copying formula itself
    By nappyjim1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2016, 02:24 AM
  2. Replies: 1
    Last Post: 02-03-2015, 06:44 AM
  3. [SOLVED] Retaining formula cell references when copying a formula to a different cell
    By FrankParisi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2013, 07:05 AM
  4. [SOLVED] copying cell without removing formula from the cell i copied from
    By raffi123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2013, 10:09 AM
  5. Replies: 1
    Last Post: 04-06-2013, 12:22 AM
  6. Replies: 7
    Last Post: 10-31-2012, 05:21 AM
  7. Copying cell value with formula
    By pal_slg in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-24-2011, 02:39 PM

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