Resubmitting a question from yesterday...formula

  • Thread starter Thread starter Peter McCaul
  • Start date Start date
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.
 
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
 
Peter,
Try
=IF(C1=0,"all stores",IF(AND(C1<>0,C1>6),"",C1))

Hope this helps

Case
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 1
Need to get cell references from a formula 7
***Help on writing a vba code 12
cell formula question 4
Vba Help with Information Extraction 0
Time Calculations Help 4
Paste Special If statement 3
Concatenate question 4

Back
Top