When I recreate the above it works for me (XL2007 & XL2010) - could you post a sample with the relevant values in place illustrating the error ?