Hi and thanks for the help. I have some calculations that show the #N/A error
because the value to correct the error will be added in the future. For now I
do not want the #N/A error visible. I know how to use conditional formatting
to make it disappear and I know how to use the =if(iserror()) method. BUT
someone showed me a formula that nested some type of NA function that took
care of the problem quite easily. I just can't remember what it is. Any
ideas? This is for version 2003. : ) THANKS