Remember Me?

#1
February 3rd 10, 05:25 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Feb 2010 Posts: 1
How do I write a formula with absolute cell references

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.

#2
February 3rd 10, 06:05 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 563
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.

#3
February 3rd 10, 06:20 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2,276
How do I write a formula with absolute cell references

Hi,
you get absolute references entering the \$ signal as follow

\$a\$1 = will keep that reference wherever you copy the formula
\$a1 = when copying the formula to your right column and row will stay the
same when copying down column will stay the same
a\$1 = when copying it to you right, will refer always to row 1

"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.

#4
February 5th 10, 08:26 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 527
How do I write a formula with absolute cell references

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.

#5
July 6th 21, 07:40 AM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
use the \$ Sign

Hello!

Using the \$ sign will make the cell an absolute reference:

\$a\$1 - A is the column and 1 is the row. If you put a dollar sign before "a", regardless of how you move the formula (copy-paste/drag), "a" will continue to be "a", and if you put \$ in front of "1", "1" will always be "1".

if \$a1 - "a" will stay the same regardless, and "1" will change

if a\$1 - "a" will change and "1" will stay the same

For more tips on excel and financial models, you can check this out. Hope this helps!

#6
March 1st 22, 03:22 AM
 Junior Member First recorded activity by ExcelBanter: May 2021 Posts: 8

NhÃ* cá»*a @

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Karen Excel Worksheet Functions 3 January 19th 09 07:10 PM Rusty Excel Discussion (Misc queries) 1 September 11th 08 05:16 PM BobC Excel Discussion (Misc queries) 3 July 21st 08 04:11 PM Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM ah666 Excel Worksheet Functions 5 June 17th 05 03:40 PM

All times are GMT +1. The time now is 11:50 AM.