View Single Post
  #2   Report Post  
Old February 3rd 10, 07:05 PM posted to microsoft.public.excel.newusers
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 563
Default How do I write a formula with absolute cell references

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.