ExcelBanter - IF funtion

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF funtion (https://www.excelbanter.com/excel-discussion-misc-queries/33250-if-funtion.html)

viddom

IF funtion

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

"viddom" wrote in message
...
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

Mike D.

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

All times are GMT +1. The time now is 04:20 PM.