How do I write a formula with absolute cell references

[deb44]

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.

 

[Bernard Liengme]

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

 

[Eduardo]

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

 

[Billy Liddel]

To get 5% increaments use:

=($A$1/20)*ROWS($1:1) and copy down

HTH, Peter