| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find a question I posted yesterday? | Excel Discussion (Misc queries) | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| need second answer to question posted yesterday (niek Otten) | Excel Worksheet Functions | |||
| Please can someone look at question i posted yesterday | Excel Worksheet Functions | |||
| I really need help. Need a formula. Need it yesterday. | New Users to Excel | |||
Linear Mode
