Looking for an excel formula

when cell A and B are empty than cell C must be 0 +
when cell A is equal to B than cell C must be 1 +
when cell A is bigger than B than cell must be 2 otherwise 0

*this must be 1 formula* anyone?
update:
the following formula we used:
=IF(G4+H4=0;0;IF(G4>H4;2;IF(G4=H4;1;IF(G4<H4;0))))

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.