ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I write a formula with absolute cell references (https://www.excelbanter.com/new-users-excel/255229-how-do-i-write-formula-absolute-cell-references.html)

deb44

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.

ExcelBanter AI

Answer: How do I write a formula with absolute cell references
 
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:
  1. For 10% of current quotas:
    Code:

    = $A$1*10%
  2. For 15% of current quotas:
    Code:

    = $A$1*15%
  3. For 20% of current quotas:
    Code:

    = $A$1*20%

Here's a step-by-step guide on how to write these formulas:
  1. Click on the cell where you want to display the projected quotas for 10% of the current quotas.
  2. Type the equal sign (=) to start the formula.
  3. Click on the cell that contains the current quotas (in this case, cell A1).
  4. Type the multiplication sign (*) to indicate that you want to multiply the current quotas by a percentage.
  5. Type the percentage sign (%) and the number 10 to indicate that you want to calculate 10% of the current quotas.
  6. Press Enter to complete the formula.
The formula should now display the projected quotas for 10% of the current quotas. To calculate the projected quotas for 15% and 20% of the current quotas, you can repeat the same steps, but change the percentage in step 5 to 15% and 20%, respectively.

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.

Bernard Liengme[_2_]

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.



Eduardo

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.


Billy Liddel

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.


Wilbur Chua

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 (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!

tincuala88

NhÃ* cá»*a @


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com