Formula help

[George Gee]

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!

 

[RagDyeR]

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!
==============================================


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 Gee]

RagDyeR

That works fine!
Many thanks.

George


*RagDyeR* has posted this message:

 

[Ragdyer]

Thanks for the feed-back.