Thread: Formula help
View Single Post
  #1   Report Post  
George Gee
 
Posts: n/a
Default 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