FUNCTIONS FOR TO TRACE THE SAME VALUE IN OTHER CELL OR SHEET
 

Is there any excell Function to trace out the same figure in the other cell
or in other sheet

FUNCTIONS FOR TO TRACE THE SAME VALUE IN OTHER CELL OR SHEET
 

"Sachin" wrote:
Is there any excell Function to trace out the same figure
in the other cell or in other sheet

Perhaps you mean something like this ..

In Sheet2,

Put in say, B2: =Sheet1!A1

B2 will return the contents in Sheet1's cell A1

If Sheet1's cell A1 is empty, B1 will return a zero

To make B2 appear "blank" if Sheet1's cell A1 is empty,
we could put instead in B2:
=IF(Sheet1!A1="","",Sheet1!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---