Formula help

Hi all

I have an IF statement:
=IF(AND(A1="Draw",B1<>C1),"Error","OK")
This works OK.

I am having trouble adding the next two statements:

=IF(AND(A1="Win",B1<=C1),"Error","OK")
=IF(AND(A1="Loose",B1>=C1),"Error","OK")

How do I combine these three statements in one IF statement?

Many thanks!


--
George

Try this:

=IF(OR(AND(A1="Draw",B1<>C1),AND(A1="Win",B1<=C1),AND(A1="lose",B1>=C1)),"Er
ror","OK")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"George Gee" <[email protected]> wrote in message
news:%[email protected]...
Hi all

I have an IF statement:
=IF(AND(A1="Draw",B1<>C1),"Error","OK")
This works OK.

I am having trouble adding the next two statements:

=IF(AND(A1="Win",B1<=C1),"Error","OK")
=IF(AND(A1="Loose",B1>=C1),"Error","OK")

How do I combine these three statements in one IF statement?

Many thanks!


--
George

RagDyeR

That works fine!
Many thanks.

George


*RagDyeR* has posted this message:

> Try this:
>
>
=IF(OR(AND(A1="Draw",B1<>C1),AND(A1="Win",B1<=C1),AND(A1="lose",B1>=C1)),"Er
> ror","OK")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "George Gee" <[email protected]> wrote in message
> news:%[email protected]...
> Hi all
>
> I have an IF statement:
> =IF(AND(A1="Draw",B1<>C1),"Error","OK")
> This works OK.
>
> I am having trouble adding the next two statements:
>
> =IF(AND(A1="Win",B1<=C1),"Error","OK")
> =IF(AND(A1="Loose",B1>=C1),"Error","OK")
>
> How do I combine these three statements in one IF statement?
>
> Many thanks!
>
>
> --
> George

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"George Gee" <[email protected]> wrote in message
news:[email protected]...
> RagDyeR
>
> That works fine!
> Many thanks.
>
> George
>
>
> *RagDyeR* has posted this message:
>
> > Try this:
> >
> >
>
=IF(OR(AND(A1="Draw",B1<>C1),AND(A1="Win",B1<=C1),AND(A1="lose",B1>=C1)),"Er
> > ror","OK")
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "George Gee" <[email protected]> wrote in message
> > news:%[email protected]...
> > Hi all
> >
> > I have an IF statement:
> > =IF(AND(A1="Draw",B1<>C1),"Error","OK")
> > This works OK.
> >
> > I am having trouble adding the next two statements:
> >
> > =IF(AND(A1="Win",B1<=C1),"Error","OK")
> > =IF(AND(A1="Loose",B1>=C1),"Error","OK")
> >
> > How do I combine these three statements in one IF statement?
> >
> > Many thanks!
> >
> >
> > --
> > George
>
>