IF funtion

[Guest]

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

 

[Nuraq]

Replace "WENN" with "IF".

 

[Guest]

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

Mike.