Try Again: IF Statement w/ Nested ANDand OR

S

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

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)
 
D

darkangelstorm

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

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

Top