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.