Excel problem

matchmaker · 19-09-2008, 11:57

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

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?

ap0gee · 19-09-2008, 12:05

Needs to be:

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

HTH

matchmaker · 19-09-2008, 12:19

Quote:

Originally Posted by ap0gee

Needs to be:

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

HTH

ap0gee · 19-09-2008, 12:24

Quote:

Originally Posted by matchmaker

Welcome! (Surprised myself with that one TBH

)

KenONeill · 19-09-2008, 13:05

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

Interphase · 19-09-2008, 14:54

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

ap0gee · 19-09-2008, 15:13

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)...

KenONeill · 19-09-2008, 15:21

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!!

matchmaker · 19-09-2008, 15:27

Quote:

Originally Posted by KenONeill

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

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

19-09-2008, 11:57	#1
matchmaker Briskodian Join Date: Aug 2004 Location: Stirling Posts: 2,794 Members Car: Black Octavia vRS Thanks: 24 Thanked 20 Times in 18 Posts	Excel problem 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 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? __________________ Alan "Darth" - Black Magic Octavia VRS with Forge DV, BMC CDA induction kit, Milltek cat, Supersprint exhaust, Xenons, ESP, cruise, parking sensors and Kumho 225/45/17 tyres Been to Star sufficient bhp & ample lb/ft All time low - 7.8 mpg

19-09-2008, 12:05	#2
ap0gee ASZ Eternal Join Date: Aug 2004 Location: Leafy Chesh-shire Posts: 6,911 Members Car: Black Magic Fabia vRS Thanks: 360 Thanked 375 Times in 325 Posts	Re: Excel problem Needs to be: =IF(Dumyat!D33=Dumyat!I33,1,0) HTH __________________

19-09-2008, 13:05	#5
KenONeill Briskodian Join Date: May 2006 Location: Normally in Scotland! Posts: 11,250 Members Car: Octavia TDi110 Thanks: 65 Thanked 562 Times in 550 Posts	Re: Excel problem Which seems do suggest that =if(Fred.cell = Joe.cell,true,false) should return false if the cells contain the same value?

19-09-2008, 14:54	#6
Interphase Briskodian Join Date: Aug 2007 Location: Leicestershire Posts: 363 Members Car: 2002 Octavia RS Thanks: 14 Thanked 32 Times in 28 Posts	Re: Excel problem I thought the first comma represents THEN and the second comma ELSE, which would return TRUE for matching values of Fred and Joe?

19-09-2008, 15:13	#7
ap0gee ASZ Eternal Join Date: Aug 2004 Location: Leafy Chesh-shire Posts: 6,911 Members Car: Black Magic Fabia vRS Thanks: 360 Thanked 375 Times in 325 Posts	Re: Excel problem 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)... __________________

19-09-2008, 15:21	#8
KenONeill Briskodian Join Date: May 2006 Location: Normally in Scotland! Posts: 11,250 Members Car: Octavia TDi110 Thanks: 65 Thanked 562 Times in 550 Posts	Re: Excel problem 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!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Question	youngsyd	The Tech Shed	17	20-02-2008 16:23
Problem open excel shortcuts	scowlsandgrowls	The Tech Shed	0	21-08-2006 15:38
Excel formula ..help	Octygone	The Tech Shed	21	27-02-2006 11:27
Any MS Excel Experts -- H E L P ! !	skodaw	The Tech Shed	6	22-01-2005 16:53
Excel question	Jon172	Off Topic and Chit Chat	13	26-03-2004 18:02

Excel problem

Excel problem

Similar Threads