Cell Equality


M

Maurice

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
 
Ad

Advertisements

D

David Biddulph

In D4, type the formula =C3

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

Ragdyer

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

Maurice

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

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Equal Cells 2
Cells equal a number 3
Sum equal cells 2
Painting equal cells 2
equals merged cells 2
count if the two cells are equal 3
Cell CODE equals #VALUE! 3
Selecting cells equals to a value 3

Top