What does absolute cell references mean and how do I use it?

[Lisa]

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.

 

[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

 

[Lisa]

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

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

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.

 

[Pieter Wijnen]

Absolute Cell Reference example. $A$1

Pieter

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

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.

 

[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

Absolute Cell Reference example. $A$1

Pieter

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

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.

 

[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

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

Absolute Cell Reference example. $A$1

Pieter

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


:

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.

 

[Lisa]

Thank you so much for helping me. I appreciate it very much.

Lisa, this is the first ref that come up with Google for search on "absolute
cell"
http://www.internet4classrooms.com/excel_percent.htm

UpRider

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

Absolute Cell Reference example. $A$1

Pieter

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


:

Need to use this in excel....happy to send a copy of what I need to
do.......any help greatly appreciated.