Home |
Search |
Today's Posts |
#1
|
|||
|
|||
returning blank cells
i know this must be simple.....but......im referencing one sheet to
another....example on sheet 2 =(sheet1!a1) ...i want the cell to be blank on sheet 2 unless there is information on sheet 1......i know this isn't brain surgery...but ive tried all the cell formats and nothing seems to return a blank on sheet 2....HELP Thanx, Mike |
#2
|
|||
|
|||
Hi!
You don't need the parenths in that formula: =Sheet1!A1 You could use this to return a formula blank: =IF(Sheet1!A1="","",Sheet1!A1) OR, use this custom format to suppress the display of 0's: 0;-0;;@ OR, goto ToolsOptionsViewZero Values Uncheck Zero Values NB: if the real cell value of Sheet1A1 is 0 then you probably wouldn't want to use the custom format or the Tools......option! Biff "menphee" wrote in message ... i know this must be simple.....but......im referencing one sheet to another....example on sheet 2 =(sheet1!a1) ...i want the cell to be blank on sheet 2 unless there is information on sheet 1......i know this isn't brain surgery...but ive tried all the cell formats and nothing seems to return a blank on sheet 2....HELP Thanx, Mike |
#3
|
|||
|
|||
menphee Wrote: i know this must be simple.....but......im referencing one sheet to another....example on sheet 2 =(sheet1!a1) ...i want the cell to be blank on sheet 2 unless there is information on sheet 1......i know this isn't brain surgery...but ive tried all the cell formats and nothing seems to return a blank on sheet 2....HELP Thanx, Mike Hi Mike This should work for you If(Sheet1!A1="","",Sheet1!A1), It's saying if Sheet1 Cell A1 is balnk, return a blank, otherwise return what is in Sheet 1 cell A1 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=399692 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
trimming blank cells | Excel Worksheet Functions | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) |