Try Again: IF Statement w/ Nested ANDand OR

[stan]

Data:

A1=x
B1=blank
C1=x

I am trying to create an IF statement which will evaluate
as TRUE IF A1=x AND B1=x OR C1=x. This one does not work
for me...

=IF(AND(A1 = "x", OR(B1 = "x", C1 = "x")), "True", "False")

I get the MS Excel Pop-Up that says there is a problem
with the formula.

Any thoughts ?

 

[Bob Phillips]

Stan,

There is nothing wrong with that formula on my machine (XP Pro, XL2000).

You don 't have a continental version of Excel perchance that uses a ;
separator?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[stan]

great call !!! i have that setting changed in control
panel / regional settings.

 

[darkangelstorm]

yes, the formula you have providing does work, what version of MS exce
you using? or are you using openoffice