Discussion:
What does absolute cell references mean and how do I use it?
(too old to reply)
Lisa
2007-10-15 09:34:00 UTC
Permalink
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
Ofer Cohen
2007-10-15 10:07:02 UTC
Permalink
You have posted the question in Microsoft Access discussion group instead of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)

In Access
Abs([FieldNum])

In Excel
=Abs(A1)

A1 - Cell Number

The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
Lisa
2007-10-15 10:36:00 UTC
Permalink
Oh I am so sorry but on the dropdown menu, it only had all Access functions
and no excel. Many apologies.

I am an absolute beginner at this and this is part of a competency test I
have to do. I have advertised for a tutor but cannot find one so thought I
would ask here for some help.

Thank you for your reply. I have no idea what it means though. Would you
mind explaining in beginner terms if that's ok.

Thank you so very much.

Lisa
Post by Ofer Cohen
You have posted the question in Microsoft Access discussion group instead of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)
In Access
Abs([FieldNum])
In Excel
=Abs(A1)
A1 - Cell Number
The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
Pieter Wijnen
2007-10-15 10:40:15 UTC
Permalink
Absolute Cell Reference example. $A$1

Pieter
Post by Ofer Cohen
You have posted the question in Microsoft Access discussion group instead of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)
In Access
Abs([FieldNum])
In Excel
=Abs(A1)
A1 - Cell Number
The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
Lisa
2007-10-15 10:54:01 UTC
Permalink
Thanks for your reply.

So, say I want an absolute cell reference for cell E15, do I put the $E$15
in the fx bar or in the cell E15?

I am so sorry to be a dummy. I have just never done this before.

Thank you for your help.

Lisa
Post by Pieter Wijnen
Absolute Cell Reference example. $A$1
Pieter
Post by Ofer Cohen
You have posted the question in Microsoft Access discussion group instead of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)
In Access
Abs([FieldNum])
In Excel
=Abs(A1)
A1 - Cell Number
The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
UpRider
2007-10-15 14:37:38 UTC
Permalink
Lisa, this is the first ref that come up with Google for search on "absolute
cell"
http://www.internet4classrooms.com/excel_percent.htm

UpRider
Post by Lisa
Thanks for your reply.
So, say I want an absolute cell reference for cell E15, do I put the $E$15
in the fx bar or in the cell E15?
I am so sorry to be a dummy. I have just never done this before.
Thank you for your help.
Lisa
Post by Pieter Wijnen
Absolute Cell Reference example. $A$1
Pieter
Post by Ofer Cohen
You have posted the question in Microsoft Access discussion group
instead
of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)
In Access
Abs([FieldNum])
In Excel
=Abs(A1)
A1 - Cell Number
The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
Lisa
2007-10-16 04:11:01 UTC
Permalink
Thank you so much for helping me. I appreciate it very much.
Post by UpRider
Lisa, this is the first ref that come up with Google for search on "absolute
cell"
http://www.internet4classrooms.com/excel_percent.htm
UpRider
Post by Lisa
Thanks for your reply.
So, say I want an absolute cell reference for cell E15, do I put the $E$15
in the fx bar or in the cell E15?
I am so sorry to be a dummy. I have just never done this before.
Thank you for your help.
Lisa
Post by Pieter Wijnen
Absolute Cell Reference example. $A$1
Pieter
Post by Ofer Cohen
You have posted the question in Microsoft Access discussion group
instead
of
Excel, but I believe the command to get the absolute number is the same in
both programs (Abs)
In Access
Abs([FieldNum])
In Excel
=Abs(A1)
A1 - Cell Number
The Abs will return the Absolute number without the sign
e.g
4 will return 4
-5 will return 5
-22 will return 22
--
Good Luck
BS"D
Post by Lisa
Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.
m***@gmail.com
2017-01-05 05:50:09 UTC
Permalink
http://tutorialway.com/use-absolute-cell-reference-in-excel/
Michael J. Strickland
2017-01-19 02:13:43 UTC
Permalink
Post by m***@gmail.com
http://tutorialway.com/use-absolute-cell-reference-in-excel/
In Excel:
Absolute cell references use a "$" prefix (e.g. "$A$1") for the
column(A) and row (1).

Relative cell references use just "A1" for the top left cell whereas
absolute cell references use "$A$1" for the top left cell.

When copying a cell formula (from a source cell to a destination
cell), the "$" prefix causes the destination cell to convert the
source formula to use the original cell specified instead of using the
cell at the same relative location to the destination cell.

Relative cell referencing is the default in Excel so that when you
copy a table of formulas that each refer to the top left cell in the
table (range) to a new table (range), your new table of formulas will
refer to the top left cell of the new table instead of the top left
cell of the original table.


Btw, "cell references" is Excel terminology unless you are using VBA
and referring to an external/embedded Excel object.

"Cells" in Access consist of a field (column of Data sheet view) of a
record (row of Data sheet view).

See you at the show trials - lol.
---------------------------------------------------
Michael J. Strickland Reston, VA
---------------------------------------------------

Loading...