close
Is there any excell Function to trace out the same figure in the other cell
or in other sheetquot;Sachinquot; wrote:
gt; Is there any excell Function to trace out the same figure
gt; 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 quot;blankquot; if Sheet1's cell A1 is empty,
we could put instead in B2:
=IF(Sheet1!A1=quot;quot;,quot;quot;,Sheet1!A1)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
全站熱搜
留言列表
