 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006FUNCTIONS 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 > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.