| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I "CORREL" statistical funtion with three or more Arrays? | Excel Worksheet Functions | |||
| Date Value Funtion in Excel 2003 returns an error, but not in Exce | Excel Worksheet Functions | |||
| If funtion wildcard | Excel Worksheet Functions | |||
| Excel funtion to find how many boxes in larger container | Excel Worksheet Functions | |||
| How do I perform operations within a funtion that operates on colu | Excel Discussion (Misc queries) | |||
Hybrid Mode
