I have a silly problem in an Excel (2007) spreadsheet. Not a complicated one by any means.

This is the formula that doesn't work.

=IF(Dumyat!D33=I33,1,0)

"Dumyat" is a sheet in a workbook. Cell D33 on the worksheet has the value 13. Cell I33 has the value 13. The formula should return the value 1. It doesn't. It returns a 0 :confused::confused:

If I change the formula to

=IF(Dumyat!D33=I33,0,1)

it produces the correct result.

I know it's a Friday, but I am getting a headache. What am I doing wrong? :O

Needs to be:

=IF(Dumyat!D33=Dumyat!I33,1,0)

HTH

Needs to be:

=IF(Dumyat!D33=Dumyat!I33,1,0)

HTH

:thumbup:

:thumbup:

Welcome! (Surprised myself with that one TBH )

Which seems do suggest that =if(Fred.cell = Joe.cell,true,false) should return false if the cells contain the same value?

I thought the first comma represents THEN and the second comma ELSE, which would return TRUE for matching values of Fred and Joe?

You're both missing that the original query said "if D33 on Dumyat worksheet = I33 on current worksheet, then '1' else '0'". So of course it's going to seem ar$e-about-face, because you're comparing cells on two different worksheets (i.e. unless cell I33 on the current worksheet happens to show the same data as I33 on Dumyat, you're going to get the FALSE result)...

Huh!? I thought that was the point; I33 on current worksheet did contain 13, and the IF was returning false. If I read the question wrong, I plead Friday!!

Huh!? I thought that was the point; I33 on current worksheet did contain 13, and the IF was returning false. If I read the question wrong, I plead Friday!!

I blame it on Friday too........I wanted to compare cells on the same worksheet :O

That was the simple part in the spreadsheet- it is getting complicated and I'm now having loving memories of Access queries :eek::eek: