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.

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.

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.

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.