| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function showing false result when it is not
Can anyone see what is wrong with this function? =IF('Employee
Details'!V4:V93="P",COUNTIF('Employee Details'!Y4:Y93,1),0) - There are loads of "P"'s in that range but it is still showing 0 as if it is false. How this makes sense. Its driving me mad!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Result = to 0 says false | Excel Worksheet Functions | |||
| Logical Format showing 0/1 and not True/False. | Excel Discussion (Misc queries) | |||
| false result | Excel Worksheet Functions | |||
| Can Excel operate a function based on a true or false result? | Excel Worksheet Functions | |||
| Excel - saving result of a function without showing the function | Excel Programming | |||
Threaded Mode
