Results 1 to 4 of 4
  1. #1


    Member Since
    Jul 28, 2009
    Posts
    2
    Angry Formulas in Numbers
    I am using numbers and we are trying to take a formula that is in the top few cells and compy it down to the rest of the cells. But the catch is, we want the multiplier to stay the same but it keeps changing. For example we have it currently doing this.. (A2*D3) And when we try to compy it down it does this (A3*D3), (A4*D4) etc..... We want the multiplier or D3 to stay the same and only the first value of the A row Change so ideally ( A3*D3), (A4*D3) etc.. This works in Excel but i cant seem to get it working in Numbers.

  2. #2


    Member Since
    Jul 27, 2009
    Posts
    56
    I think this from the help pages in numbers may well answer your question - you would need to make the D3 your absolute reference I think


    Distinguishing Absolute and Relative Cell References
    Use absolute and relative forms of a cell reference to indicate the cell to which you want the reference to point if you copy or move its formula.

    If a cell reference is relative (A1):
    When its formula moves, it stays the same. However, when the formula is cut or copied and then pasted, the cell reference changes so that it retains the same position relative to the formula cell. For example, if a formula containing A1 appears in C4 and you copy the formula and paste it in C5, the cell reference in C5 becomes A2.
    If the row and column components of a cell reference are absolute ($A$1):
    When its formula is copied, the cell reference doesn’t change. You use the dollar sign ($) to designate a row or column component absolute. For example, if a formula containing $A$1 appears in C4 and you copy the formula and paste it in C5 or in D5, the cell reference in C5 or D5 remains $A$1.
    If the row component of a cell reference is absolute (A$1):
    The column component is relative and may change to retain its position relative to the formula cell. For example, if a formula containing A$1 appears in C4 and you copy the formula and paste it in D5, the cell reference in D5 becomes B$1.
    If the column component of a cell reference is absolute ($A1):
    The row component is relative and may change to retain its position relative to the formula cell. For example, if a formula containing $A1 appears in C4 and you copy the formula and paste it in C5 or in D5, the cell reference in C5 and D5 becomes $A2.
    Here are ways to specify the absoluteness of cell reference components:
    Type the cell reference using one of the conventions described above.

    Click the disclosure triangle of a cell reference and choose an option from the pop-up menu.

    Select a cell reference and press Command-K to cycle through options.

  3. #3


    Member Since
    Jul 28, 2009
    Posts
    2
    Thank you, this helps alot!!

  4. #4


    Member Since
    Jul 27, 2009
    Posts
    56
    Quote Originally Posted by MissaRay View Post
    Thank you, this helps alot!!
    happy to be of assistance - let us know if it works and you get it sorted.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formulas
    By rodder in forum OS X - Apps and Games
    Replies: 6
    Last Post: 02-10-2013, 08:13 AM
  2. formulas
    By rodder in forum Switcher Hangout
    Replies: 4
    Last Post: 02-09-2013, 03:28 PM
  3. Please help me with Numbers formulas.
    By Shawn Koh in forum OS X - Apps and Games
    Replies: 4
    Last Post: 12-14-2012, 11:21 AM
  4. Formulas in Number
    By macuser3 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 04-16-2011, 06:09 AM
  5. HELP!! iWork Numbers formulas
    By MazdaspeedK in forum OS X - Apps and Games
    Replies: 0
    Last Post: 03-03-2010, 06:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •