OR formula, ?????

  • Thread starter Thread starter apache007
  • Start date Start date
A

apache007

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top