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.