| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text from one sheet cell to appear in another sheet cell | Excel Worksheet Functions | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
| Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
