I know I should know this

  • Thread starter Thread starter mdj0615
  • Start date Start date
M

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.
 
Maybe you want something like this:
=if(sheet1!g14="","",sheet1!g14*.075)


Regards,
Fred.
 
Back
Top