Thanks for reply gbobs, What I am trying to do is have a blank result if any of the cells in equation are blank. This happens in both equations above. the only difference is that one is divided by and the other is multiplied by. (trying not to have worksheet cluttered up with 0's).
Thanks again