Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.newusers




How do I write a formula with absolute cell references
I am trying to write a formula with absolute cell references for the following;
Determine the projected quotas at 10% of the current quotas. 15% of the current quotas and 20% of the current quotas. 
#2
Posted to microsoft.public.excel.newusers




How do I write a formula with absolute cell references
If the 'current quota' is a number in A1
In B1 enter =($A$1/10)*COLUMN(A1) to compute 10% of its value Copy to C1 to compute 20%, etc best wishes  Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "deb44" wrote in message ... I am trying to write a formula with absolute cell references for the following; Determine the projected quotas at 10% of the current quotas. 15% of the current quotas and 20% of the current quotas. 
#3
Posted to microsoft.public.excel.newusers




How do I write a formula with absolute cell references
Hi,
you get absolute references entering the $ signal as follow $a$1 = will keep that reference wherever you copy the formula $a1 = when copying the formula to your right column and row will stay the same when copying down column will stay the same a$1 = when copying it to you right, will refer always to row 1 "deb44" wrote: I am trying to write a formula with absolute cell references for the following; Determine the projected quotas at 10% of the current quotas. 15% of the current quotas and 20% of the current quotas. 
#4
Posted to microsoft.public.excel.newusers




How do I write a formula with absolute cell references
To get 5% increaments use:
=($A$1/20)*ROWS($1:1) and copy down HTH, Peter "deb44" wrote: I am trying to write a formula with absolute cell references for the following; Determine the projected quotas at 10% of the current quotas. 15% of the current quotas and 20% of the current quotas. 
#5




use the $ Sign
Hello!
Using the $ sign will make the cell an absolute reference: $a$1  A is the column and 1 is the row. If you put a dollar sign before "a", regardless of how you move the formula (copypaste/drag), "a" will continue to be "a", and if you put $ in front of "1", "1" will always be "1". if $a1  "a" will stay the same regardless, and "1" will change if a$1  "a" will change and "1" will stay the same For more tips on excel and financial models, you can check this out. Hope this helps! 
#6




NhÃ* cá»*a @

Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Absolute Cell References  Excel Worksheet Functions  
absolute cell references  Excel Discussion (Misc queries)  
Cell References absolute?  Excel Discussion (Misc queries)  
convert relative cell references to absolute cell references via amacro?  Excel Discussion (Misc queries)  
Absolute References in cell formula  Excel Worksheet Functions 