what does this mean?

[Maureen]

I'm using someone else's spreadsheet and I'm trying to figure out what this means: =IF(AND(D7>0,F7<>"CANCELLED"),1,0) Anybody????

[Colin Legg]

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")