That formula means

If D7 is greater than zero and F7 does not equal the word "CANCELLED" then return 1, otherwise return 0.

This formula would also return the same result:

=(D7>0)*(F7<>"CANCELLED")