New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Formulas in Numbers


Post Reply New Thread Subscribe

 
Thread Tools
MissaRay

 
Member Since: Jul 28, 2009
Posts: 2
MissaRay is on a distinguished road

MissaRay is offline
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.
QUOTE Thanks
judderman62

 
Member Since: Jul 27, 2009
Posts: 56
judderman62 is on a distinguished road

judderman62 is offline
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.
QUOTE Thanks
MissaRay

 
Member Since: Jul 28, 2009
Posts: 2
MissaRay is on a distinguished road

MissaRay is offline
Thank you, this helps alot!!
QUOTE Thanks
judderman62

 
Member Since: Jul 27, 2009
Posts: 56
judderman62 is on a distinguished road

judderman62 is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Hebrew Calendar | Convince me to buy iWork. »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
re-acquiring registration numbers (apple & Adobe) markameeks OS X - Apps and Games 3 07-11-2009 01:30 AM
Copying data from email into numbers on iMac Andy and Shell Apple Desktops 0 03-08-2009 05:22 PM
Cutting and Pasting from emails into Numbers Andy and Shell Switcher Hangout 0 03-08-2009 05:20 PM
How to make Page Numbers default Word doc generdude OS X - Apps and Games 2 03-02-2009 04:09 PM
Numbers - amazed at it! PapaNoHair OS X - Apps and Games 0 06-25-2008 06:33 PM

All times are GMT -4. The time now is 12:43 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?