Can I hide the error triangle thing in a cell?

generally you can "trap" the errors the trianlges are warning you about by using the function IFERROR().

if the cell contains:

=SUM(B1:G1)

then you can trap the error like this:

=IFERROR( SUM(B1:G1) , "")

which indicates the return the empty string when the sum produces an error

Haddy,

If you hover over the error triangle, you will get a message. In this case, it's not a bad formula, it's a "divide by zero" error. You are being warned that the result of dividing by zero is "undefined".

You can trap the error, but it's even better in my book to sidestep the error. In your case, you could change the formula in Total Percent from:

=G/C

to

=IF(C>0, G/C, "")

What we are doing is is making sure we aren't dividing by zero before we divide.

Regards,

Jerry