route217
asked on
If formula to return 0 when same and 1 when different
Hi Experts using excel 2010
I havethe following if formula...
IF(BB19=BA19,0,IF(BC19=BB1 9,0,IF(BD1 9=BC19,0,I F(BE19=BD1 9,0,IF(BF1 9=BE19,0,1 )))))
Which should when the previous date is the same as current date return 0 and when different return 1...cannot get it to work. Keeps on returning 0 all the time.
I havethe following if formula...
IF(BB19=BA19,0,IF(BC19=BB1
Which should when the previous date is the same as current date return 0 and when different return 1...cannot get it to work. Keeps on returning 0 all the time.
can u upload a sample file. the reason you get zero is that in all nested IFS the condition for true is 0 so that would mean that any of these BB19=BA19 BC19=BB19 BD19=BC19 BF19=BE19 are returning true meaning that any of these equal statement are true and therefore it will not reach to the end.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Firstly thanks for the feed back still get a zero.
So.assume row 1
Date 1 Date 2 Date 3 Date 4
Rows 2
01/02/16 02/02/16 02/02/16 03/02/16
Hence end result should be 2 date 1 and 2 are different and 3 and 4..
So.assume row 1
Date 1 Date 2 Date 3 Date 4
Rows 2
01/02/16 02/02/16 02/02/16 03/02/16
Hence end result should be 2 date 1 and 2 are different and 3 and 4..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Apologies projimjam..
End result should be 2 hence two date differences. My fault.. sorry.
End result should be 2 hence two date differences. My fault.. sorry.
please see attached.
Book1.xlsx
Book1.xlsx
Open in new window