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.