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