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

[Sachin]

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

[Max]

"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
---