make one cell identical to another

G

Guest

Simple question:

I want to make a cell on one sheet show an identical value to a similarly
positioned cell on another sheet. The values in the cells on both sheets are
used for mathematical calculations.

However, there are blanks in some of the cells that i want to match as well.

Problem is if I use the "=" function, then the cell that's doing the copying
will show a zero if the original cell was a blank.

Is there another function that I can use? Essentially, if I copy a blank
cell, I want a blank cell to result, not one with a zero in it.

anand
 
G

Guest

Hi,

You can have the cell show blank by replacing something like =A1 with
=IF(A1="","",A1)
 

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

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Identical Cells in Multiple Worksheets in one Workbook. 4
How does a function provide a blank cell as a result 2
When I link blank cell in one sheet registers as 0 for averaging 3
extracting data from one cell to another 8
Write data from one cell to another cell 1
when setting a cell to equal a blank cell it displays 0 2

Top