|Did you test my latest suggestion?|
As far as I can tell you have asked for a formula to deal with 3 conditions:
If A1 is greater than B1, C1 = A1
If B1 is greater than A1, C1 = 0
If A1 equal B1, C1 = Not Good
My lastest suggestion handles all 3 of those conditions.
=IF(A1=B1, "Not Good", IF(A1>B1, A1, 0))
May I suggest that you spend some time reading the Excel Help files on the IF function. Google can also provide a lot of help and examples on all Excel functions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.