I know I should know this
 

I have created a spreadsheet to use at school. On sheet one I have a column
for names, and on sheet two I have the function =Sheet1!C9, etc. I also have
the formula =Sheet1!G14*.075 through out the sheet. Why are there zeros in
all of these boxes now on sheet 2, and how do I get rid of them??? I guess
they don't affect much, it's just making the sheet a little overwhelming to
look at.

I know I should know this
 

Maybe you want something like this:
=if(sheet1!g14="","",sheet1!g14*.075)


Regards,
Fred.

"mdj0615" wrote in message
...
I have created a spreadsheet to use at school. On sheet one I have a
column
for names, and on sheet two I have the function =Sheet1!C9, etc. I also
have
the formula =Sheet1!G14*.075 through out the sheet. Why are there zeros
in
all of these boxes now on sheet 2, and how do I get rid of them??? I
guess
they don't affect much, it's just making the sheet a little overwhelming
to
look at.