I think I'd use:

=IF(SNPT!C110="","",SNPT!C110)

Just in case C110 on SNPT really contained a 0.

Pete wrote:

For the first question you can use conditional format on the cell -
conditions: if cell contents = 0, set foreground colour to background
colour (white?)

For the second question you can do a similar thing as in your first
formula, i.e.

=IF(SNPT!C110 = 0,"",SNPT!C110)

Pete

--

Dave Peterson