Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 (copy-paste/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 | |
|
|
![]() |
||||
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 |