Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 10, 05:25 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 1
Default 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   Report Post  
Old February 3rd 10, 06:05 PM posted to microsoft.public.excel.newusers
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.


  #3   Report Post  
Old 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
Default 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   Report Post  
Old February 5th 10, 08:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 527
Default 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   Report Post  
Old July 6th 21, 07:40 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute Cell References Karen Excel Worksheet Functions 3 January 19th 09 07:10 PM
absolute cell references Rusty Excel Discussion (Misc queries) 1 September 11th 08 05:16 PM
Cell References absolute? BobC Excel Discussion (Misc queries) 3 July 21st 08 04:11 PM
convert relative cell references to absolute cell references via amacro? Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM
Absolute References in cell formula ah666 Excel Worksheet Functions 5 June 17th 05 03:40 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017