Great. I wanted to avoid the embedded IF but without it the formula always
evaluates the MOD, and errors if you input C1 etc. The IF means the MOD
doesn't get evaluated if the value is not 1 and < 999999.

--
__________________________________
HTH

Bob

"Seanie" wrote in message
...
Thanks Bob that seems to work exactly the way I want it to