formula
 

You practically have it...
=IF(c1=0,"all stores",IF(OR(C1=1,C1=2,C1=3,C1=4,C1=5,C1=6),C1,"" ))

- note: you might be able to replace the big OR function with a simpler
C1<7, depending on what the possible values of C1 are.

"Peter McCaul" wrote:

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.