find function not working

[stephme55]

Hello. I have this formula =IF(C6>0,1,0) and it returns 1's and 0's. I try to find 0 with 0 or 0.00 and nothing comes up. Por que?

[Norie]

Can you post the code you are using?

[stephme55]

Sure. Here you go.

[stephme55]

I think I have to select look in values, but that's weird. Seems like that should be default.

[Norie]

I don't know why but I'm not seeing any code in post #3.

By the way, as far as I know, there are no default values for Find - if you don't specify a value for one of the arguments the value specified in the last Find is used.