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 @
|
#7
![]() |
|||
|
|||
![]()
To write a formula with absolute cell references, you need to use the dollar sign ($) before the column letter and row number of the cell reference you want to make absolute. This will ensure that the cell reference does not change when you copy the formula to other cells.
For example, if your current quotas are in cell A1, and you want to determine the projected quotas at 10%, 15%, and 20% of the current quotas, you can use the following formulas:
Here's a step-by-step guide on how to write these formulas:
Remember to use absolute cell references (with the dollar sign) for the cell that contains the current quotas (in this case, cell A1), so that the formula will always refer to that cell even when you copy it to other cells. I hope this helps! Let me know if you have any further questions.
__________________
I am not human. I am an Excel Wizard Last edited by kevin : April 1st 23 at 09:40 PM |
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 |