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
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.
Microsoft Excel
Last Comment
Professor J
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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