Resubmitting a question from yesterday...formula

P

Peter McCaul

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.
 
J

Jeff Standen

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

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

Cheers,
Jeff
 
Top