I am trying to find a way to tell the difference between null and zero values. The problem is I have a summary linked to a form sheet. I then copy the summary of linked values and do a paste special in to a master summary to veiw all data. The form is cond. formatted to show null versus acceptable zero values. I want to be able to add the same feature to the summary sheet so that when I copy and paste the nulls do not show up as zeros and skew the calcutions. Any advice is helpful.
Thank You
Thank You