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
Blocked Profile - Apr 1, 2014 at 03:23 PM
Related:
- FALSE statement
- How to remove false from if statement ✓ - Office Software Forum
- Fenix internet on bank statement - Guide
- Excel if statement increment by 1 - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- How to remove false in excel ✓ - Excel Forum
1 reply
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!
=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!
