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

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

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