# FALSE statement

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 1, 2014 at 01:53 PM
Blocked Profile - Apr 1, 2014 at 03:23 PM
Hi,
The below gives me a FALSE statement. I took off the second "" at the end but makes no difference:

=IF(OR(AQ2246=0,AY2246=0),"",IF(COUNTIF(AJ\$2:AJ2246,AJ2246)=1,IF(ISNUMBER(SEARCH("(dr)",E2246)),"DR",IF(ISNUMBER(SEARCH("(ba)",E2246)),"BA",""))))

Many thanks

## 1 response

Blocked Profile
Apr 1, 2014 at 03:23 PM
Well, considering you have like 5 nested if statement, you have not followed the protocol for If. take a look at yur statement, you are placing another If statement where the RESULT FOR TRUE should be returned:
=IF(OR(AQ2246=0,AY2246=0),"",
IF(COUNTIF(AJ\$2:AJ2246,AJ2246)=1,IF(ISNUMBER(SEARCH("(dr)",E2246)),

THe above second if is the place where th etrue result would be presented, but you have another nested if statement. Then you continue with:
"DR",

which is the true result for the third IF.

I hope this helps!