Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"George Gee" wrote in message
...
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" wrote in message
...
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