iWork numbers formulae

[Alfaman1970]

Hi, I have a question about formulae in iWork numbers relating to the following problem.

I have 3 numerical cells, A, B and C

I want to input figures in cells A and B to give a certain return in C

The criteria I am using are as follows:

IF A>B THEN IF TRUE C=2, IF FALSE C=0
OR
IF A=B THEN C=1 EXCEPT IF A=0 THEN C=0

Can any please help with writing a formula for this?

 

[Kaveman]

=IF( 'A'=0,0,IF( 'A'='B',1, IF('A' >'B',2,0 )))

 

[Alfaman1970]

=IF( 'A'=0,0,IF( 'A'='B',1, IF('A' >'B',2,0 )))

Thanks Kaveman - works a treat ;-)