I am having a problem with this function.

I would like to look up a cell in sheet1
if the cell value is 0 then I would like the cell on sheet2 to read
-----
if the cell value is anything else I would like the value of that cell
to populate the new cell

I have it working halfway with this formula

=IF(Sheet1!C1=0," ","Sheet1!C3")

I get the ----- when I need it but get Sheet1!C3 instead of the value
sheet1 cell C3 contains.

I tried =IF(Sheet1!C1=0," ","=Sheet1!C3") but that didn't work.
i searched the net but couldn't find the answer there either.

Any possible help for a newbie?

All this is to help my cause of generating cleaner code when using
excel data to make a table in an HTML email. When I create the code
Dreamweaver HTML editor will only put borders around cells with values
in them. &nbsp is the value for 'NON BREAKING SPACE' which displays as
a blank.

But I can not get the value of the cell to display if it is not
originally blank on sheet1