Cell Equality
 

I would like to establish two cells, one taking its value from the other.
For example, What value is found in C3 will automatically be placed in say,
D4. I am a novice and could not find this calculaton in the function option.
Advice sought

Cell Equality
 

In D4, type the formula =C3

If you don't want D4 to show zero when C3 is empty, then use
=IF(C3="","",C3)
--
David Biddulph

"Maurice" wrote in message
...
I would like to establish two cells, one taking its value from the other.
For example, What value is found in C3 will automatically be placed in
say,
D4. I am a novice and could not find this calculaton in the function
option.
Advice sought

Cell Equality
 

Click in D4 and enter an equal sign ( = ),
Click in C3, and hit <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Maurice" wrote in message
...
I would like to establish two cells, one taking its value from the other.
For example, What value is found in C3 will automatically be placed in
say,
D4. I am a novice and could not find this calculaton in the function
option.
Advice sought

Cell Equality
 

Much thanks for the timely and successful solution. I would like to include
one additional functon. I need to create a cell, say B2 to reflect the
amount of say C8 minuse E8. The continued support is well appreciated.

"David Biddulph" wrote:

In D4, type the formula =C3

If you don't want D4 to show zero when C3 is empty, then use
=IF(C3="","",C3)
--
David Biddulph

"Maurice" wrote in message
...
I would like to establish two cells, one taking its value from the other.
For example, What value is found in C3 will automatically be placed in
say,
D4. I am a novice and could not find this calculaton in the function
option.
Advice sought

Cell Equality
 

In B2:

=C8-E8
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Maurice" wrote in message
...
Much thanks for the timely and successful solution. I would like to
include
one additional functon. I need to create a cell, say B2 to reflect the
amount of say C8 minuse E8. The continued support is well appreciated.

"David Biddulph" wrote:

In D4, type the formula =C3

If you don't want D4 to show zero when C3 is empty, then use
=IF(C3="","",C3)
--
David Biddulph

"Maurice" wrote in message
...
I would like to establish two cells, one taking its value from the
other.
For example, What value is found in C3 will automatically be placed in
say,
D4. I am a novice and could not find this calculaton in the function
option.
Advice sought

Cell Equality
 

Maurice

See Ragdyer's response for a formula.

Please don't take this as criticism but perhaps a bit of basic training could
help.

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 09:26:09 -0800, Maurice
wrote:

Much thanks for the timely and successful solution. I would like to include
one additional functon. I need to create a cell, say B2 to reflect the
amount of say C8 minuse E8. The continued support is well appreciated.

"David Biddulph" wrote:

In D4, type the formula =C3

If you don't want D4 to show zero when C3 is empty, then use
=IF(C3="","",C3)
--
David Biddulph

"Maurice" wrote in message
...
I would like to establish two cells, one taking its value from the other.
For example, What value is found in C3 will automatically be placed in
say,
D4. I am a novice and could not find this calculaton in the function
option.
Advice sought