Ok, so that's my problem. I thought there was a formula error when the formula has to be written. But if that's true then really all I'm doing is a lot of formula writing when I could just write it out on paper. So then it begs the question why use excel at all.......Ok, I'm done with it. Thank you for all of your effort and help. The thread can be closed, good-bye.