This will work as long as you are only worried about integer values.

=IF(C1=0,"all stores",IF(AND(C10,C1<7),C1,""))

Cheers,
Jeff

"Peter McCaul" wrote in message
...
I posted this question yesterday but I don't think it got through so I'm
posting it again. Thanks for any help in advance.

In cell f14 i'm trying to write a function that will do this:

if c1=0 "all stores", (if c1=1,2,3,4,5,6, c1) if equal to anything else
"".

How would I write this? Thanks once again for the help.