| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks very much RagDyeR.
Kevin "RagDyeR" wrote: Just replace the last 0 in the formula with a null ( "" ). =IF(OR(A1={"RED","BLUE","GREEN","BLACK","ORANGE"}) ,1,"") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "kevin" wrote in message ... One more complication, when using this formula in say cell d1, and if there is no value in a1 it returns a 0 in d1, is there a way to include an (ifblank , return a blank,) statement in the formula so that nothing appears in the cell until an entry is made in the input cell. Just so that there is not a long string of 0's. Thanks Kevin "RagDyer" wrote: Try this: =IF(OR(A1={"RED","BLUE","GREEN","BLACK","ORANGE"}) ,1,0) I'm sure you're talking Text here, and *not* the actual colors of the cell. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "kevin" wrote in message ... Once again thanks for your help folks. Could someone show me how to write the following if statement. =IF(A1=RED OR BLUE OR GREEN OR BLACK OR ORANGE,1,0) I know these would all need to be in "" but I am not sure what separator to use. -- Thanks Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Include Saturday in the WORKDAY function | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
| Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Hybrid Mode
