Doug wrote:
Not sure why it is not working. Everything you said makes sense, I went back
and checked all the number formats, etc. I will just have to play around and
maybe look up the details to the functions you gave me. You have helped a
great deal.


Did you just check the number formats, or did you actually confirm that there
are numbers in the cells, following the directions I gave previously?

Also, make sure that the numbers exactly match what you expect them to be, for
example make sure it is .02 in the cell and not .020000001 formatted to show
only 2 decimal places.