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

S

Sachin

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

Max

Sachin said:
Is there any excell Function to trace out the same figure
in the other cell or in other sheet
Click to expand...

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)
 
Top