| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function showing false result when it is not
Amy-Marie pretended :
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!!! How do you know the zero is not the result of there being none of your COUNTIF criteria? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
| 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 | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
