View Single Post
  #3   Report Post  
CarlosAntenna
 
Posts: n/a
Default

=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.