Resubmitting a question from yesterday...formula
 

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.

Resubmitting a question from yesterday...formula
 

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.

Resubmitting a question from yesterday...formula
 

Try,

IF(C1<0,"",IF(C1=1,"all stores",IF(C1<=6,C1,"")))

Fred

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

Resubmitting a question from yesterday...formula
 

Peter,
Try
=IF(C1=0,"all stores",IF(AND(C1<0,C16),"",C1))

Hope this helps

Case

--
Message posted from http://www.ExcelForum.com