Coming up with #N/A
 

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.

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.

.

=IF(ISNA('Client Info'!I6-2 ),0,'Client Info'!I6-2 )

Carlos

"Rj" wrote in 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.

Sorry when I went to post this it said I had an error and it would not post.

"Rj" wrote:

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.

Thank you it is working out great.

"Rj" wrote:

Sorry when I went to post this it said I had an error and it would not post.

"Rj" wrote:

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.