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
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel if statement - Guide
- Vba case statement - Guide
1 response
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!
