Excel equation: If nested (true and False formula)

[zyko_234]

Hi,

I have an equation below that should return a 1 if true (which is working) and a 0 otherwise for any other values (which is working partially). So for some items it is returning 0 but for others it is returning a FALSE which should be a 0 if the equation was working correctly.
[FONT=&quot]
=(IF(EXACT(BQ48,"OLD"),IF(EXACT(BW48,"testoriginal"),1,0)))[/FONT]

Any help is appreciated!

Thanks!

 

[Eric W]

Welcome to the Board!

Try:

=IF(EXACT(BQ48,"OLD"),IF(EXACT(BW48,"testoriginal"),1,0),0)

or

=IF(AND(EXACT(BQ48,"OLD"),EXACT(BW48,"testoriginal")),1,0)

 

[Fluff]

If they both need to be true, try
=IF(AND(EXACT(BQ48,"OLD"),EXACT(BW48,"testoriginal")),1,0)

 

[Eric W]

If you're comfortable with Boolean algebra, you could even use:

=EXACT(BQ48,"OLD")*EXACT(BW48,"testoriginal")