Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
You practically have it...
=IF(c1=0,"all stores",IF(OR(C1=1,C1=2,C1=3,C1=4,C1=5,C1=6),C1,"" )) - note: you might be able to replace the big OR function with a simpler C1<7, depending on what the possible values of C1 are. "Peter McCaul" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |