Cell referencing SC

S

sreeram.i.c

My question is if I have cell A1 in Sheet2 that is referenced to cell
A2 in Sheet1, I give the formula =Sheet1!A2.
If i do not have any value in A2 in sheet1 then the value shown in A1
in Sheet2 is "0", I do not want this to happen. I want it to be
cosidered as blank only and not 0. Please help me with a formula.
 

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

Can I sort and not lose reference to the cell? 3
SUMIF function and cell /sheet reference 3
vlookup + if formula help! 7
Fill formula down for cells 74 rows apart 3
Cell Referencing 2
Offset to a referenced cell 2
Offset in another sheet 2
A formula that autofills by trend rather than linear 1

Top