Prev: Export to XML is not exporting all records
Next: Import hexadecimal data into excel keeping hexadecimal format
From: apache007 on 23 Feb 2010 19:19
I have Worksheet A containing a list of data:
Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR

Worksheet B on CELL A1, is user input data

A2 has the following formula
=OR(A1=COLOR)

User input : Red = FALSE
Yellow = FALSE
Orange = True
Purple = FALSE

The OR formula should produce TRUE value on the cell for all input that is
true. However, it is not the case. Where is the formula wrong?
From: Pete_UK on 23 Feb 2010 20:20
Try this instead:

=ISNUMBER(MATCH(A1,COLOR,0))

Hope this helps.

Pete

On Feb 24, 12:19 am, apache007 <apache...(a)discussions.microsoft.com>
wrote:
> I have Worksheet A containing a list of data:
> Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR
>
> Worksheet B on CELL A1, is user input data
>
> A2 has the following formula
> =OR(A1=COLOR)
>
> User input :  Red    =  FALSE
>                   Yellow  = FALSE
>                    Orange = True
>                   Purple   = FALSE
>
> The OR formula should produce TRUE value on the cell for all input that is
> true. However, it is not the case. Where is the formula wrong?

From: מיכאל (מיקי) אבידן on 24 Feb 2010 01:53
Your formula should be working as expected if it will be treated as an
'Array-Formula'.
{=OR(A1=COLOR)}
Which means:
It is to be confirmed with CTRL+SHIFT+ENTER rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
“Excel”, when the formula is entered as an Array formula.
Micky


"apache007" wrote:

> I have Worksheet A containing a list of data:
> Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR
>
> Worksheet B on CELL A1, is user input data
>
> A2 has the following formula
> =OR(A1=COLOR)
>
> User input : Red = FALSE
> Yellow = FALSE
> Orange = True
> Purple = FALSE
>
> The OR formula should produce TRUE value on the cell for all input that is
> true. However, it is not the case. Where is the formula wrong?
 | 
Pages: 1
Prev: Export to XML is not exporting all records
Next: Import hexadecimal data into excel keeping hexadecimal format