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
|