| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I write a formula for If And statements ex. if = to ? and
Example if column="red" or column="green","white" otherwise "blue"?
I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? and
MacroLearning
if(AND(A1="Red",A1="Green"),"White","Blue") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "MacroLearning" wrote in message ... Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? a
It seems that it's only reading the last value "blue" not the first -
therefore making them all blue. "Nick Hodge" wrote: MacroLearning if(AND(A1="Red",A1="Green"),"White","Blue") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "MacroLearning" wrote in message ... Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? a
Try not to break the threads, I posted in the original...should have been OR
not AND -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "MacroLearning" wrote in message ... It seems that it's only reading the last value "blue" not the first - therefore making them all blue. "Nick Hodge" wrote: MacroLearning if(AND(A1="Red",A1="Green"),"White","Blue") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "MacroLearning" wrote in message ... Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? and
Perhaps this......
IF(OR(A1="Red",A1="Green"),"White","Blue") Vaya con Dios, Chuck, CABGx3 "MacroLearning" wrote: Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? and
Looked past the obvious, just spotted the missing braces. They still apply
but use OR rather than AND if you only want to match either rather than both -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "CLR" wrote in message ... Perhaps this...... IF(OR(A1="Red",A1="Green"),"White","Blue") Vaya con Dios, Chuck, CABGx3 "MacroLearning" wrote: Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I write a formula for If And statements ex. if = to ? and
If there's a chance you have to check more values in A1, you may find this
easier to type: =IF(OR(A1={"Red","Green"}),"White","Blue") Just keep adding more "colors" inside those {}'s. MacroLearning wrote: Example if column="red" or column="green","white" otherwise "blue"? I use If, And but do not get a value. Any help? =if(AND A1="Red",A1="Green","White","Blue") -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fiveif statements in a formula | Excel Worksheet Functions | |||
| If, Then statements with a formula | Excel Discussion (Misc queries) | |||
| Can I create a formula with more than 8 IF statements? | Excel Discussion (Misc queries) | |||
| How can I have multiple "If" statements in one formula? | Excel Discussion (Misc queries) | |||
| Formula Help Combing two AND statements | Excel Worksheet Functions | |||
Hybrid Mode
