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

Message posted on the January 30th, 2012 - 2:31 PM ET

Bug#551981: bzr-builddeb: --result option is documented as --result-dir

This is a multi-part MIME message sent by reportbug. MIME-Version: 1.0 Package: bzr-builddeb Version: 0.95 Severity: minor Tags: patch Hi, the documentation obtained using `bzr help builddeb' contains the following text: $ bzr help builddeb ...

Message posted on the October 22nd, 2009 - 05:00 am ET

OR function produces incorrect result

I am testing the "OR" function and it seems to produce a false result even when only one of two logical arguments is false (that is, it is acting like the AND function that requires all arguments to be true). Here is the formula I wrote: ...

Message posted on the December 15th, 2009 - 07:58 am ET

Colour change depending on result

Hi all, Is it possible to make the true result of an IF statement, say, green and the false result, say, red? I would like to be able to do this without using VBa s I have no experience of using it. Simon

Message posted on the September 29th, 2009 - 03:06 am ET

#Error for False

Hi Groupies This Nested IIF statement returns #Error for the False result. Can anybody see why? I am missing it... RegHrs: IIf([Payroll Rule]="8 Daily - 44 Weekly" And [Total Time]<=8,[Total Time],IIf([Payroll Rule]="10 Daily - ...

Message posted on the May 20th, 2010 - 03:25 pm ET

Problem about "csptestsuite.exe" result for "CPAcquireContext" fun

Hi all! I've implemented a Smart Card CSP of type "PROV_RSA_SIG", and it's "CPAcquireContext" function is as below: BOOL WINAPI CPAcquireContext( OUT HCRYPTPROV *phProv, IN LPCSTR szContainer, IN DWORD dwFlags, IN ...

Message posted on the June 28th, 2009 - 09:04 am ET

[PATCH] sysfs: get rid of some lockdep false positives

This patch (as1554) fixes a lockdep false-positive report. The problem arises because lockdep is unable to deal with the tree-structured locks created by the device core and sysfs. This particular problem involves a sysfs attribute method that ...

Message posted on the May 14th, 2012 - 01:40 pm ET

Bug#642013: network-manager: managed=true/false still rewrites resolv.conf, unable to network regardless

Package: network-manager Version: 0.9.0-2 Severity: important Each time my system starts up, the file /etc/resolv.conf is overwritten by NetworkManager. As as result, DNS stops working. I've tried managed=true and managed=false. I have the ...

Message posted on the September 18th, 2011 - 11:10 am ET

Need "true" or "false"

Hi All, I need the column f2 to show whether it is true or false. Below is the scenario A1 B1 C1 D1 E1 F1(result) s s s s s s s y s y I need the ...

Message posted on the January 25th, 2010 - 02:34 pm ET

Nested If with VLookup result a 0

Good day, I'm getting a 0 (zero) when I use the following IFERROR statement in Excel 2007: =IFERROR(VLOOKUP(A7,Reports!$A$1:$V$1000,6,FALSE),"") I originally used just the VLookup Function, but when the reference cell (A7) was blank, I ...

Message posted on the September 16th, 2009 - 12:39 pm ET

Using a vlookup to search multiple criteria for one result?

HI all!! Thank you for time and knowledge. I am looking for a vlookup to search multiple criteria for one result? Below is my workbook with 2 sheets. The "Name" column in "Sheet 1" is blank. This is where I want to put the ...

Message posted on the March 11th, 2013 - 04:10 pm ET

Help with small result type

Hi to all expert, I am running kind of a complex query and I want to know why I get the result as a string instead of a number/currency, the math is good : SELECT BasicRental.IdBranch, Nz(Round(IIf(Nz(IIf(Eval([DateTo] Between ...

Message posted on the May 21st, 2010 - 09:17 am ET

[PATCH] wait: fix false timeouts when using wait_event_timeout()

Many callers of the wait_event_timeout() and wait_event_interruptible_timeout() expect that the return value will be positive if the specified condition becomes true before the timeout elapses. However, at the moment this isn't guaranteed. If the ...

Message posted on the May 02nd, 2013 - 05:00 am ET

Comparing two ranges and get true or false in one cell depending on result

Hi all How do I compare two alike ranges with one formula and get result as true or false. Ranges are alike = true Not alike = false Cheers

Message posted on the June 08th, 2009 - 08:21 am ET

		Advanced search
In