Hi. I think your formula should be =IF(A162="M",IF(Z162=$X$1,1," ")," ").

Mike.

"viddom" wrote:

I have this formula IF(A162="M",WENN(Z162=$X$1,1," ")," "), but eventhough
A162="M" and Z162=$X$1 the result is not 1, but " " can somebody tell me
what's wrong with it