Formula help

  • Thread starter Thread starter George Gee
  • Start date Start date
G

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!
 
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!
 
Back
Top