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.