returning blank cells

[Guest]

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

 

[Biff]

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 Tools>Options>View>Zero 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

 

[Paul Sheppard]

i know this must be simple.....but......im referencing one sheet to
another....example on sheet 2 =(sheet1!a1) ...i want the cell to b
blank on
sheet 2 unless there is information on sheet 1......i know this isn'
brain
surgery...but ive tried all the cell formats and nothing seems t
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 A