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
Microsoft Excel MVP
"deb44" wrote in message
I am trying to write a formula with absolute cell references for the
Determine the projected quotas at 10% of the current quotas.
15% of the current quotas and 20% of the current quotas.