The simplest (but not always the most efficient) way
would be to trap the error using:

=IF(ISNA(your_formula),0,your_formula)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want G11 to = Zero if I6 is left alone how do I do
this. other wise it
gives me #N/A and this messes up the whole page.

here is the formula that I am using
='Client Info'!I6-2
Thanks for any help.

.