Coming up with #N/A

[Rj]

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.

 

[Jason Morin]

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

 

[CarlosAntenna]

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

Carlos

 

[Rj]

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

 

[Rj]

Thank you it is working out great.

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