The formula as I posted it looks fine. I tried it just to be sure and
had no problems. Did you copy/paste the formula? Try typing it out
manually instead of copy/paste.

In article ,
Btaylor64 wrote:

Domenic,
Looks like there's a parentheses issue in the formula below? I tried
to troubleshoot this using the colored parenthese font that Excel provides,
but no luck. All the combinations of parentheses placement I've tried give
me errors...
Any thoughts?
Gratefully,
-Brett