Try Again: IF Statement w/ Nested ANDand OR

  • Thread starter Thread starter stan
  • Start date Start date
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 ?
 
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)
 
yes, the formula you have providing does work, what version of MS exce
you using? or are you using openoffice
 
Back
Top