I know I should know this

[mdj0615]

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.

 

[Fred Smith]

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


Regards,
Fred.